Re: Dynamic SQL Execution in Stored Procedure

From: New Age <parbha_at_iquest.net>
Date: 1996/01/26
Message-ID: <DLrDLD.CIp_at_iquest.net>#1/1


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.
 

>Good Luck
>--
> ______________________________
> / /\
> | Francois ARNE |_/
> | email : arne_at_micronet.fr |
>___|________________________ |
>\___________________________\__/

Use DBMS_SQL (oracle supplied package) to do so. Received on Fri Jan 26 1996 - 00:00:00 CET

Original text of this message