cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Senior Member

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        

Watch a new Video