| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> PL and bind variables
I was made some excercises with PL/SQL and some questions arrived to my mind.
I was wondering if is could be posible assign a table or column name to a variable and use that variable in a SQL statement within PL/SQL code.
In the PL/SQL manual exists some references to this, but the examples are with programming languages and embeded PL/SQL code. I checked this with the local Oracle representative. The response that I get was that I must use bind variables to do this, but I get an error in compile time about an invalid or bad use of a bind variable.
Can somebody tell me if is posible use variables to store tables or column names for queries in PL/SQL code?
--
Saludos...
Best regards...
Eduardo Rene Rodriguez Avila
E-Mail: e.r.rodriguez_at_ieee.org _/ _/
eravila_at_geocities.com _/ _/
eravila_at_spin.com.mx _____/
WWW : http://spin.com.mx/~eravila
http://www.geocities.com/CapeCanaveral/8319
Received on Wed Feb 26 1997 - 00:00:00 CST
![]() |
![]() |