Forum Discussion

NaveenKumar11's avatar
NaveenKumar11
Occasional Contributor
6 years ago

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"

    • NaveenKumar11's avatar
      NaveenKumar11
      Occasional Contributor

      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.