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

[NaveenKumar11]

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"

[HimanshuTayal]

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

[NaveenKumar11]

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.