Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tricky Dynamic SQL question

Re: Tricky Dynamic SQL question

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 27 Dec 2002 04:24:28 -0800
Message-ID: <1efdad5b.0212270424.46a46ae7@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US