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
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
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.