Re: Executing SQL Statement in PL/SQL Block

> From: Sameer Dhawan <Sameer_Dhawan.DEL01_at_INTL.RX.XEROX.COM>
> PROBLEM :
> I want to run the contents of a variable declared in a PL/SQL block.
> for example if a variable named TEST is of char TYPE and contains
> the following text "DELETE BOOKS;" then this SQL statement must be
> executed from within the PL/SQL block..

Look in the RDBMS directory for the PL/SQL package (DBMSSQL I think) that allows you to do dynamic sql inside pl/sql.

Bruce...

   T T T T T T T T        Bruce Pihlamae
   I I I I I I I I        bpihlama_at_nla.gov.au
   I I I I I I I I        National Library of Australia
   T T T T T T T T        Phone: +616 262-1480
  -----------------       Fax:   +616 273-2116
 ===================