Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Automation of installation
Hi,
I feel u should not put these into a Proc... if u 'r using Unix then go ahead and write a script that will do that ...
The Script wil call Sql Plus and the do all these whenever there is a error it will jump out of SQl Plus...
So i feel that is simple then writting Dynamic SQl to Do this thru a Procedure which is going to be cumbursome.
HTH
Regards,
Ganesh R
"Patrick J." <patrick.jollain_at_kneip.com> wrote in message news:<3c21af61$1_2_at_news.vo.lu>...
> Hi,
>
> For the set-up of an application running under Oracle 8.1.7, I need a quite
> complex procedure that will:
> - create tables and constraints
> - compile about 100 packages
> - create triggers on tables
> - insert initial data into tables
>
> I would like to write an automated procedure to do this and stop as soon as
> an error is detected, such as an error when creating a table or compiling a
> package.
> What is the best way to achieve this goal?
>
> Thanks,
>
> Patrick J.
Received on Thu Dec 20 2001 - 07:53:27 CST