Oracle-L: Re: Executing SQL Statement in PL/SQL Block

From: Subramaniam, Sridhar <SSubrama_at_NIBUCORP.CCDN.OTC.COM.AU>
Date: Tue, 2 Jan 1996 01:24:26 -0500
Message-Id: <9601020631.AA28688@alice.jcc.com>

Try using dynamic sql ( DBMS_SQL ). Check for the docu in the O7.1 PL/SQL addendum.

Sridhar Subramaniam
Telstra Corporation
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au

avion_at_ozemail.com.au

From: owner-oracle-l
To: Multiple recipients of list ORACLE-L Subject: Executing SQL Statement in PL/SQL Block Date: Tuesday, 2 January 1996 2/30PM

Dear Oraclities,

I would appreciate if any one could provide solution to the following problem
:-

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.. Received on Tue Jan 02 1996 - 01:31:41 CST