Dynamically spescifying a select clause for a cursor

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 23 1998 - 00:00:00 CST