how cursor use global temporary table?
Posted on 2008-10-08
I am trying to create a global temporary table and cursor can use that. Since temporary
table not exist yet, got an compile error saying table my_temp_table not
exist. (see pseudo code) below. is there any way to get around or should I
take a different approach like using collection? thanks,
create or replace procedure test
cursor my_cur is
execute immediate 'create global temporary table my_temp_table as .....";
open my_cur for loop ....