Re: Dynamic SQL Execution in Stored Procedure
From: Phil Perucci <pperucci_at_access4.digex.net>
Date: 1996/01/25
Message-ID: <4e7tas$e2g_at_access4.digex.net>#1/1
Date: 1996/01/25
Message-ID: <4e7tas$e2g_at_access4.digex.net>#1/1
In article <4e6d60$jr_at_chleuasme.francenet.fr>,
Francois ARNE <arne_at_micronet.fr> wrote:
>>Does anyone know if it's possible to dynamically execute a SQL statement
>>in Oracle stored procedure or function?
>
>Yes it is possible and it works very good.You can can have dynamic SQL in
>procedure, package body and function.
Rookie here...
Anyway, I think this was introduced with Oracle 7.1 & PL/SQL 2.1 and implemented as a PL/SQL "package".
-- ============================================================================== Phil Perucci ......... pperucci_at_access.digex.net ........ Systems Integrator "Visit the Hydrologic Information Center at http://www.nohrsc.nws.gov/~hic" ==============================================================================Received on Thu Jan 25 1996 - 00:00:00 CET