Re: Dynamic SQL within PL/SQL Block

Alan D. Mills wrote:
>
> 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.
>

But certainly. It's called DBMS_SQL

Christian Received on Mon Apr 20 1998 - 08:11:31 CDT