Home » SQL & PL/SQL » SQL & PL/SQL » Reference Cursor Variable for Dynamic Tables?
Reference Cursor Variable for Dynamic Tables? [message #365399] Wed, 22 April 1998 19:28 Go to next message
Samson
Messages: 1
Registered: April 1998
Junior Member
Does any one know if it is possible to open a reference cursor variable for a dynamically created table? Essentially,

DECLARE
TYPE cursortype IS REF CURSOR;
curvar cursortype;
BEGIN
...
OPEN curvar FOR SELECT * FROM mytable;
END;

where mytable is known only during runtime and unknown at compile time.

Report message to a moderator

Re: Reference Cursor Variable for Dynamic Tables? [message #365576 is a reply to message #365399] Mon, 30 November 1998 16:19 Go to previous message
Sheon
Messages: 4
Registered: November 1998
Junior Member
You'll have to use DBMS_SQL to use a dynamically created table and you use CURSOR instead of REF CURSOR in block statements.

Report message to a moderator

Previous Topic: Re: Buffer limit in DBMS_OUTPUT
Next Topic: non-alpha,non-numeric characters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 05:42:21 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.