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"
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
Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓
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
Subject | Author | Latest Post |
---|---|---|