Re: using table pointers in select?

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 09 Aug 2007 13:37:32 -0000
Message-ID: <1186666652.319204.27800@j4g2000prf.googlegroups.com>

On Aug 9, 7:07 am, "aksel.schmidt" <axl.schm..._at_gmail.com> wrote:
> > Look up 'Dynamic SQL' in your PL/SQL documentation.
>
> dynamic sql is probably the solution, but not easily as stated inhttp://download.oracle.com/docs/cd/B14117_01/appdev.101/b10807/11_dyn...
> 'You cannot use placeholders for the names of schema objects. For the
> right way, see "Passing Schema Object Names As Parameters".' (http://
> download.oracle.com/docs/cd/B14117_01/appdev.101/
> b10807/11_dynam.htm#i14257)
>
> thanks again
> /aksel

Hi,

execute immediate *is* dynamic SQL (not native, but still dynamic SQL). Regards,

Steve Received on Thu Aug 09 2007 - 08:37:32 CDT