Forum Discussion

ANDYtyara's avatar
ANDYtyara
Occasional Contributor
8 years ago

How to call stored procedures from JDBS request test step.

Hi Team,
I am having one oracle store procedure craeted with IN and OUT parameters in ORACLE database.
I am trying to call it from SOAP 5.2.1 version with JDBS request test step.
Can you please tell me how to call store procedure with input and output parameters?

 

Also do i need to mention all input and output parameters in property list first ? and also how to pass them while calling store

 

procedure? Also how to view DB procedure returned output?

 

It would be helpful if you explain with one example.

 

Your help would be appreciated.

  • ANDYtyara's avatar
    ANDYtyara
    Occasional Contributor
    8 years ago

    Hi ,

     

    I called store procedure with input and output parameters and got response us

     

    <Results>
        <UpdateCount>-1</UpdateCount>
    </Results>

     

    What does this UpdateCount ,-1 stands for? Can anyone help me out?

     

     

    Called store procedure with

     

    {call Store_Procedure_Name(:InputParameterName,:OutputParameterName)}