NaveenKumar11
6 years agoOccasional 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"