Re: Tricky Dynamic SQL question

Why dont you try weakely typed ref cursors.

for eg

declare

c sys_refcursor;

begin

• Get the table name v_table_name := fn_get_the_table_name();

  open c for ' select * from ' || v_table_name;

end;

• rajXesh

--

Posted via http://dbforums.com Received on Thu Dec 26 2002 - 09:17:09 CST