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

Jim Lewis wrote:

> 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.
>
>

Hi Jim,
This is definitely not an optimal solution - but have you considered a simple UNIX shell script? Example:

    for SCRIPT in `ls *.sql`
    do
      sqlplus usr/pwd $SCRIPT
    done

HTH,
Avi. Received on Tue Oct 31 2000 - 06:30:41 CET