Message-Id: <10522.108337@fatcity.com> From: "Scott Shafer" Date: Fri, 9 Jun 2000 00:22:17 -0500 Subject: Re: create a batch file to execute script Call the second script within the first one, i.e., Script 1: select blah...... / insert bleech... / @script2 ---End of script1------- ----- Original Message ----- From: "B, Ravindra" To: "Multiple recipients of list ORACLE-L" Sent: Friday, June 09, 2000 12:54 AM 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@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----- > Sent: Thursday, June 08, 2000 11:16 PM > To: Multiple recipients of list ORACLE-L > > > Put parameters after the executable. > > First parameter is the login. > Second is the script. > > plus33.exe scott/tiger@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@fatcity.com [mailto:root@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@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@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@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@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: B, Ravindra > INET: Ravindra.B@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@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