Re: PL and bind variables

Eduardo Rene Rodriguez Avila wrote:
>
> 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.

  You can implement it by using dynamic SQL. In other words, the use of DBMS_SQL package.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.