Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky Dynamic SQL question
rajXesh <member_at_dbforums.com> wrote in message news:<2318730.1040915829_at_dbforums.com>...
> 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
I cant anchor my record dynamically. Received on Fri Dec 27 2002 - 06:24:28 CST