Home -> Usenet -> c.d.o.tools -> Creating a cursor from a VARCHAR2

Creating a cursor from a VARCHAR2

From: Allan Martin <allan.martin_at_saic.com>
Date: Wed, 19 Sep 2001 09:32:30 +0100
Message-ID: <3ba7f574_at_cpns1.saic.com> 





Hi,



[Quoted] I have a cursor like.....



CURSOR cur_get_info IS



    SELECT * FROM .........;


However, I'd like to create the cursor so that instead of typing in the
SELECT statement, it comes from a string. i.e.



    CURSOR cur_get_info IS



         [my VARCHAR2];



Any advice would be great.



Thanks,


Allan Martin
Received on Wed Sep 19 2001 - 10:32:30 CEST












Original text of this message