I want to have a temporary table, so I make use of the cursor. However, inside my program, I am appending records from this cursor, so I tried using the INSERT command. But this won't work.

Any work around where I can have a temporary table then be able to add records into it?

TIA.