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


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

Original text of this message