Re: PL/SQL script to execute multiple .sql files?
Date: Mon, 30 Oct 2000 22:08:43 +0100
Message-ID: <8tknke$1vl$1_at_nereid.worldonline.nl>
Why do this from PL/SQL. Try and write a Unix shell script that picks up the scripts and execute sqlplus for each one!
Toine.
Jim Lewis <pojpl_at_ais.ucla.edu> schreef in berichtnieuws
8tkhkp$i35$1_at_carroll.library.ucla.edu...
> We have about 100 WebDB scripts to execute on our production server to
> migrate reports from development to production.
>
> We have consulted the PL/SQL Programming manual for help in writing a
> PL/SQL script that will go through the WebDB scripts directory
> executing them all in turn. Unfortunately, we haven't come up with
> anything yet.
>
> Can anyone share such a script with us. Our production machine is a
> Sun, running Solaris 7, by the way.
>
> Thank you in advance.
>
>
>
Received on Mon Oct 30 2000 - 22:08:43 CET