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: using table pointers in select?

Re: using table pointers in select?

From: aksel.schmidt <axl.schmidt_at_gmail.com>
Date: Thu, 09 Aug 2007 04:07:38 -0700
Message-ID: <1186657658.056396.190090@22g2000hsm.googlegroups.com> 





> Look up 'Dynamic SQL'  in your PL/SQL documentation.




dynamic sql is probably the solution, but not easily as stated in
http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10807/11_dynam.htm#i13130;
'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
Received on Thu Aug 09 2007 - 06:07:38 CDT












Original text of this message













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