Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: executing a list of DDL statements in one call
Jerwynn wrote:
>
> Hi,
>
> I need to execute several DDL statements, specifically CREATE OR
> REPLACE FUNCTION command (which is read from a file). PL/SQL begin ...
> end doesn't allow DDL statements inside.
> Is there another way to run the DDL statements in one call?
>
> Oracle has a CREATE PACKAGE command, which can contain several
> functions. However, I want my FUNCTIONS to be created in the
> top-level. Thanks.
>
> Regards,
>
> Jerwynn Lee
why not creating a script containing all of your ddl-orders and setting them as one transaction which will be given to the svrmgrl?
--
salut d'Allemagne kr