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: Passing table names as parameter to a PL/SQL program

Re: Passing table names as parameter to a PL/SQL program

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 2 Oct 2001 07:49:41 -0700
Message-ID: <9pck65010dq@drn.newsguy.com>


In article <fcb331b6.0110020617.2eea60f1_at_posting.google.com>, gloriaz_ca_at_yahoo.com says...
>
>Hi there,
>I need to pass two table names as parameters to a PL/SQL program. One
>of the table name will be used in a cursor. I would appreciate it if
>you could please provide a solution for me.
>
>Thanks so much in advance.
>Gloria

sigh, never a version. ok, we'll guess "8i or up"

see
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a77069/10_dynam.htm#4376 "Native Dynamic SQL"

read about dbms_sql before that.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Tue Oct 02 2001 - 09:49:41 CDT

Original text of this message

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