setting a ref cursor to existing open cursor
From: joe seefeldt <jseefeldt_at_nlvl.com>
Date: 1998/01/21
Message-ID: <34C61B1F.2E41377F_at_nlvl.com>#1/1
TYPE recOutString IS
RECORD
(vVal1 varchar2(255));
I would like to open the cursor, check the ROWCOUNT, and return a value accordingly.
Date: 1998/01/21
Message-ID: <34C61B1F.2E41377F_at_nlvl.com>#1/1
Using Netsacpe Livewire to hit an Oracle 8.x database. The Java SS LiveWire DB layer needs a ref cursor defined as an in out parameter in a stored procedure.
Question: Is ther a way to open a cursor and then set a reference to it?
The documentation suggests defining the
Record Type and Ref Cursor type and then opening the ref cursor in the
SP:
TYPE recOutString IS
RECORD
(vVal1 varchar2(255));
TYPE rRecOutString is REF CURSOR RETURN recOutString;
FUNCTION get_something(rCur_io IN OUT rRecOutString)
RETURN INTEGER
IS
... blah blah ...
OPEN rCur_io
FOR
SELECT a lot of stuff FROM some table
I would like to open the cursor, check the ROWCOUNT, and return a value accordingly.
Thanks,
Joe Seefeldt
jseefeldt_at_nlvl.com
Received on Wed Jan 21 1998 - 00:00:00 CET