Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: executing a list of DDL statements in one call

Re: executing a list of DDL statements in one call

From: Manu <emmanuel.pl.bontemps_at_wanadoo.fr>
Date: Tue, 15 Jun 1999 10:52:24 +0200
Message-ID: <7k548n$3og$1@oceanite.cybercable.fr>


Or try to use DBMS_SQL package to generate dynamically DML or DDL statement.

Jaros aw Palka a écrit dans le message <3765F4D2.D5B97336_at_kamsoft.com.pl>...
>> I need to execute several DDL statements, specifically CREATE OR
>> REPLACE FUNCTION command (which is read from a file). PL/SQL begin ...
>(...)
>> Jerwynn Lee
>
>dbms_utility.exec_ddl_statement('CREATE ...');
>
>____________________________________________________________
>Jaroslaw Palka <jarek_at_kamsoft.com.pl> P.I.KAMSOFT, Katowice
>tel./fax (+48 32)255-59-93, 256-37-58, 256-46-50 POLAND
Received on Tue Jun 15 1999 - 03:52:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US