Re: Dynamic SQL within PL/SQL Block

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 20 Apr 1998 15:27:16 +0100
Message-ID: <6hfm1v$dhc$1@schbbs.mot.com>

Ok panic over. I found it - DBMS_SQL

--
Alan D. Mills

To email remove NOSPAM from address.
Alan D. Mills wrote in message <6hf5og$5g9$1_at_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 - 09:27:16 CDT