SmartBear Connect 2018
Join us at SmartBear Connect 2018 on October 29th & 30th in Boston, MA.
Apply to speak and share your experience with the greater SmartBear Community
Reply
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