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 unable to execute the SP, can someone help me with the declaration?

Example Call Statement which is used in SQL Query box of JDBC Test Request:

CALL "SCHEMA NAME "."SP NAME"('INPUTPARAMETER1','INPUTPARAMETER2','INPUTPARAMETER3',?,?,?);
? are output parameters.



Any help is appreciated.