cancel
Showing results for 
Search instead for 
Did you mean: 

how to execute/call stored procedure from soap ui open source tool

Highlighted
Occasional Contributor

how to execute/call stored procedure from soap ui open source tool

Hi All,

Please help me to execute/call stored procedure from soap ui open source tool. I am looking for syntax or sample code to proceed further.

 schema name: SID_SRCH 

stored proc name: CUSTOMER_TEXT_SEARCH

 

This stored proc contains 9 input parameters and 1 output parameters 

polnumber - varchar2 (200)

ssn - varchar2 (200)

firstname - varchar2 (200)

lastname - varchar2 (200)

dob - varchar2 (200)

city- varchar2 (200)

state- varchar2 (200)

zip- varchar2 (200)

productline - varchar2 (200)

phonenumber- varchar2 (200)

user_cur - SYS_REFCURSOR

 

Please help me to frame query to enter under "SQL Query" under "JDBC Request"

2 REPLIES 2
Highlighted
Community Leader

Re: how to execute/call stored procedure from soap ui open source tool

Hi @NaveenKumar11,

 

Hope below article will help you, i haven't to that much hand-on on Calling Stored Procedure via SoapUI, but below one will try

 

JDBC-Stored-Procedure-Call

 

 


Click "Accept as Solution" if my answer has helped, and remember to give "kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
Highlighted
Occasional Contributor

Re: how to execute/call stored procedure from soap ui open source tool

Thanks for your response. Based on the link you shared i have tried below,

 

execute SID_SRCH.CUSTOMER_TEXT_SEARCH('23902072','1234','john','pistorio','1952-07-15','Vincenne','Indiana','47591','45454','4561237892',SYS_REFCURSOR)

 

error message

  • INFO:Error getting response for [Copy of JDBC Request]; java.sql.SQLException: ORA-06550: line 1, column 15: PLS-00103: Encountered the symbol "SID_SRCH" when expecting one of the following: := . ( @ % ; immediate The symbol ":=" was substituted for "SID_SRCH" to continue.
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors