Re: REF CURSOR used as an INOUT parameter in a stored procedure

I had the exact same problem, and I finally got an answer from oracle. They do not support
the use of a ref cursor as an in out parameter. To get around the problem, we created functions
that return a ref cursor. This way, the ref cursor is only an out parameter and you can code this:
cstmt.registerOutParameter(1, OracleTypes.CURSOR); to bind your first output variable. were cstmt
is a callable statement.

Matthew Field wrote:

> Hi everyone,
>
> I need to call some stored procedures from within a java app. These
> procedures use a REF CURSOR as an INOUT parameter. It is fairly clear
> from the RefCursorExample.java how to do this when the REF CURSOR is an
> OUT but I have not been able to track down what setXXX to use or what to
> set it to.
>
> I know that the REF CURSOR as an OUT has been addressed here before but
> I find no evidence of it being addressed as an INOUT.
>
> Thanks in advance for any help
> Matthew Field
> mfield_at_wi.jdtv.com
Received on Tue Feb 03 1998 - 00:00:00 CST