RE: create a batch file to execute script

I know that is possible...but how to call the second script outside the first one........

ravindra

-----Original Message-----
From: Scott Shafer [mailto:scott.shafer_at_ildmail.com] Sent: Friday, June 09, 2000 11:56 AM
To: Multiple recipients of list ORACLE-L 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 ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, June 09, 2000 12:54 AM

> 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-----
> 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_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
> also send the HELP command for other information (like subscribing).
> --
> 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: Scott Shafer
  INET: scott.shafer_at_ildmail.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