Forum Discussion

jeetendrae's avatar
jeetendrae
New Contributor
7 years ago

call Procedure having output parameters in JDBC Test Step not showing value of output variable

Hi All, I have created a Stored Procedure with Output parameter, which gives me the result set in MySQL successfully, But when I try to call same procedure using JDBC Test Step in SoapUI, I am no...
  • jeetendrae's avatar
    7 years ago

    Thank You !!!

     

    Yes. JDBC TestStep doesn't have a way to get the output variable, so I have to used Groovy Script here.

     

    Once I called stored procedure with: {call getActors(@cgetActorsnt)} then I have added one more step to get value of output variable from the called store procedure as below:

     

    // To get the value of output variable from the called store procedure
    def valueOfOutputVariable = con.rows("select(@cnt)")

     

    valueOfOutputVariable displayed the count as 200 which is expected and matching as per the database query.