Forum Discussion

rajash's avatar
rajash
Contributor
10 years ago

Executing stored procedure from JDBC Request

Hi People, I am using JDBC Test Step to execute a Db2 Stored procedure. The Stro proc contain output parameters one Int, Varchar and datetime. My DB Connection is successful. However I am una...
mamar's avatar
mamar
Contributor
10 years ago
I tried by executing the below query and it works for me. Please try the again.


try
{
 sql.call("call sdamq03.ASGN_USER_ROLE_S1('11111', '222', '11', '111', 'Active');")
}catch (Exception ex)
{
 log.info ex.message
}catch (Error er)
{
 log.info er.message
}