Re: executing a list of DDL statements in one call

Thanks karsten,

  How do I set them as one transaction? Is it using the "Begin transaction....."
Will it work in case I need to read the script from a text file, and send it to the server using my program, bypassing SQL plus?

Thanks again.

Regards,
Jerwynn Lee

karsten reincke wrote:

> 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
> -----------------------------------
> les chats cont les vrais hédonistes
> et devraient être donc notre idéal.
> -----------------------------------
> karsten reincke [ 0541/9696223 ]
> kreincke_at_cl-ki.uni-osnabrueck.de
Received on Tue Jun 15 1999 - 20:44:35 CDT