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.

3 Replies

  • 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
    }


  • NaveenKumar11's avatar
    NaveenKumar11
    Occasional Contributor

    Hi,

    Did your query resolved?

    I am looking answer for the same query.