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/8319Received on Wed Feb 26 1997 - 00:00:00 CST
![]() |
![]() |