Re: PL/SQL script to execute multiple .sql files?

Sorry for my english

Hi

in a "go.sql" file write this :

start firstscript.sql;

start secondscript.sql;

etc ...

save go.sql
start go.sql under sqlplus

in fact it's a sqlplus file
if you have a problem : try '/' to replace ';' look for problem of oracle_path

Jim Lewis <pojpl_at_ais.ucla.edu> a écrit dans le message : 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 Tue Oct 31 2000 - 19:21:01 CET