Re: Dynamic SQL within PL/SQL Block

From: Reinhard Bergander <reinhard_bergander_at_compuserve.com>
Date: Mon, 20 Apr 1998 21:51:44 +0100
Message-ID: <353BB560.FF8D41AC@compuserve.com>

You should take a closer look at the dbms_sql Package (supplied with RDBMS 7.3)

Alan D. Mills schrieb:

> 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 - 15:51:44 CDT