RE: create a batch file to execute script

I would recommend either calling the second script at the end of the first script,
or
making a third script that simply calls the other two: plus33.exe scott/tiger_at_my_db @script3

script3.sql::
@@script1
@@script2
exit

HTH,
Steve Monaghan

> -----Original Message-----
> From: B, Ravindra [mailto:Ravindra.B_at_Compaq.com]
> Sent: Friday, June 09, 2000 12:42 AM
> To: 'ORACLE-L_at_fatcity.com'
> Cc: 'Steve.Monaghan_at_wcom.com'
> Subject: RE: create a batch file to execute script
>
>
> Steve,
>
> Thanks for the mail.It worked for me.
>
> What if I want to execute two scripts in the same sqlplus session.
> I tried
>
> plus33.exe scott/tiger_at_my_db @script1 @script2
>
> But this doesn't work.The second script doesn't get executed.
>
> How can I do this.Pls advice.
>
> Regards,
> Ravindra
>
> -----Original Message-----
> From: Steven Monaghan [mailto:Steve.Monaghan_at_wcom.com]
> Sent: Thursday, June 08, 2000 11:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: create a batch file to execute script
>
>
> Put parameters after the executable.
>
> First parameter is the login.
> Second is the script.
>
> plus33.exe scott/tiger_at_my_db @script1
>
> We do this all the time here on NT. Works file. We even have
> looping batch
> files to kick off scripts every so many minutes. Put an exit at
> the end of
> the script if you want the window to close when done.
>
> Steve Monaghan
> Worldcom
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of B, Ravindra
> > Sent: Thursday, June 08, 2000 10:18 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: create a batch file to execute script
> >
> >
> > How can i create a batch file under windows Nt platform that will invoke
> > sqlplus and run a
> > sql file for me.i was able to create a batch file that will execute the
> > plus33.exe and log in
> > as system user.But i was not able to get the script (c.sql) executed.
> >
> > pls advice
> >
> > thanks,
> > ravindra
> > --
> > Author: B, Ravindra
> > INET: Ravindra.B_at_compaq.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Author: Steven Monaghan
> INET: Steve.Monaghan_at_wcom.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Jun 09 2000 - 08:07:11 CDT