cancel
Showing results for 
Search instead for 
Did you mean: 

Executing stored procedure from JDBC Request

Contributor

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.
3 REPLIES 3
Contributor

Re: Executing stored procedure from JDBC Request

any help on this pleasE?
Contributor

Re: Executing stored procedure from JDBC Request

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
}


Occasional Contributor

Re: Executing stored procedure from JDBC Request

Hi,

Did your query resolved?

I am looking answer for the same query.

New Here?
Join us and watch the welcome video:
Top Kudoed Authors