Hi All,
I am not able to trigger the store PROC from LISA using DB test step, Can some one share the sample test case.
i need to read the OUT parameters by passing all the IN and OUT values to the store PROC
What Database are you using? The syntax can vary, here is the syntax for an oracle DB stored procedure (Oracle Express sample HR DB) with 2 parameters (IN, INOUT):
{call hr.getjobid(?,?)}
It is DB2 data base and do we need to define OUT parameters any where/ if we mention in {{}} that will suffice?.
You can define the parameters as properties either before or right in the JDBC Step and using property notation {{PROP1}} With Stored Procedures returning parameters make sure you uncheck the "Returns Result Set" box.
Hi Karl,
Called the StoreProcedure using the JDBC Step {call PKG_XYZ(?,?,?,?,?)}
KEY CHAR(200) IN CODE VARCHAR2(200) IN CURSOR REF_CURSOR OUT N_ERR_NUM NUMBER OUT V_ERR_MSG VARCHAR2(200) OUT I have declared the output parameters in the properties but its not working .
its giving the error message as below.
There was a SQLException: java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'PKG_SELECT_REIMB.GETFSAACCOUNTSUMMARY' must be declared
ORA-06550: line 1, column 7:Please help me on this
You can define the parameters as properties either before or right in the JDBC Step and using property notation {{PROP1}} With Stored Procedures returning parameters make sure you uncheck the "Returns Result Set" box.