referring to a temp table in a procedure?

[Quoted] [Quoted] I don't know if this is a trivial question but I am hitting [Quoted] [Quoted] the wall now. Any help will be very appreciated!!!

What I want to do is

In a strored procedure,

  create a temp table;

  insert some rows to the temp table;

  create a cursor on the temp table;

  Loop thru the temp table with the DBMS_OUTPUT;

It seems to me DBMS_SQL is the only way to go but...

   Can what I want be achieved? how?

Thank you very much.

Leslie Received on Tue Nov 12 1996 - 00:00:00 CET