Cursor Variables and Dynamic SQL

From: George <info_at_expohire.com.au>
Date: Thu, 11 Jun 1998 17:05:49 +1000
Message-ID: <357F81CD.5FE3@expohire.com.au>

Is it possible to use an OPEN CURSOR command in DBMS_SQL.parse() and return the cursor to a cursor variable??

eg.

PACKAGE type_dec

        TYPE result_cursor IS REF CURSOR;
END; PROCEDURE dynamic_cursor_test(tcurList IN OUT type_dec.result_cursor) DECLARE

	cid		INTEGER;
	cursor_record	cursor_variable%ROWTYPE;

BEGIN
	cid = DBMS_SQL.open_cursor;
	DBMS_SQL.parse(cid,'OPEN tcurList FOR 
				SELECT .......',DBMS_SQL.v7);
	DBMS_SQL.close_cursor(cid);

END; Does the tcurlist parameter now point to a cursor??

Thanks in advance
George Received on Thu Jun 11 1998 - 02:05:49 CDT