Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 ===================Received on Tue Jan 02 1996 - 01:31:38 CST
![]() |
![]() |