Forum Discussion

sahanarangain's avatar
sahanarangain
New Contributor
13 years ago

call Procedure having output parameters in JDBC Test Step

Hi all,
I have created a Stored Procedure which has both Input and Output parameters, 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 not able to retrieve the result set.
I need proper syntax to call Stored Procedure for the same.

In MySQL i have created stored procedure named: SampleEXInOut
which I am calling as follows:

call SampleEXInOut('c++',@value);
select @value;

which would fetch me the result set as
id
---
2

where @value is my Output parameter.

Same I am calling in SoapUI as: SampleEXInOut('c++',@value)
need to know how result set can be retrived for the same using outputparameters
No RepliesBe the first to reply