Forum Discussion

namitabhadviya's avatar
namitabhadviya
Senior Member
7 years ago

How to run stored procedure which has some input parameter and one REFCURSOR as a output parameter

I want to run oracle stored procedure which has some input parameter and REFCURSOR as output parameter.

I am using the following stmt to run the query

sql.call '{call stored proc name(?, ?, ?, ?, ?, ?, ?)}',['21-JUN-17 20:03:00',123,'XXX','22-JUN-2017','ORD','OB',Sql.resultSet(OracleTypes.CURSOR)]

 

Please suggest        

No RepliesBe the first to reply