sahanarangain
13 years agoNew Contributor
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
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