Re: Dynamically spescifying a select clause for a cursor

Try the DBMS_SQL builtin packge. This lets you run dynamic SQL from within a PL/SQL procedure.

John Thwaites
AlliedSignal Inc. - Polymers

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;
> 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
Received on Mon Mar 30 1998 - 00:00:00 CST