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
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