opening a ref cursor in dynamic sql

[JUKe]

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