Re: Dynamically spescifying a select clause for a cursor

On Mon, 23 Mar 1998 16:19:55 -0600, fkgrass_at_hotmail.com wrote:

>How do I dynamically specify the select for a cursor. Here is what I want to
>do. This is just an example of what i want to do.
>declare
>c_cursor cusor;
>l_sql long:= 'select * from dual';
>begin
> open c_cursor for l_sql;
> for em in c_cursor loop
> ....
> end loop;

 Keep in mind that for loop implicitly opens and closes your cursor.
>end;
>
>Any ideas?
>
>Thanks,
>Fred Grass
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de