Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic SQL within PL/SQL Block

Dynamic SQL within PL/SQL Block

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 20 Apr 1998 10:49:07 +0100
Message-ID: <6hf5og$5g9$1@schbbs.mot.com> 





Is there any mechanism for executing dynamic SQL within PL/SQL in Oracle
7.3.



Basically we want to perform an update statement with the update statement
built dynamically into a large(ish) VARCHAR2 variable.  We need some
mechanism for executing the thing.



I seem to remember that there is a package that might help with this.  If so
could anyone remind me what it is.



Replies by email if possible



--


Alan D. Mills



To email remove NOSPAM from address.


Received on Mon Apr 20 1998 - 04:49:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US