i have a stored procedure, with a ref cursor variable as an out parameter say cur_v, which creates a table, say tab_abc, in the execute immediate statement.
so i populate tab_abc in the body of the stored procedure.
and at the end of the procedure i need to open the cursor, cur_v with the contents of the table, tab_abc.
a simple "open... select.. from... " would suffice, but the table is non existent during the time of the compilation hence it s throwing a compilation error, table does not exist, at compilation
so i populate tab_abc in the body of the stored procedure.
and at the end of the procedure i need to open the cursor, cur_v with the contents of the table, tab_abc.
a simple "open... select.. from... " would suffice, but the table is non existent during the time of the compilation hence it s throwing a compilation error, table does not exist, at compilation