troubleshooting Question

Execute multiple scripts using SQLPLUS via a batch file

Avatar of servantis
servantis asked on
Oracle Database
3 Comments2 Solutions18779 ViewsLast Modified:
I need to automate the execution of 10 script files in sequence. I am working in a windows environment and so am using a batch file to execute the script.

SQLPLUS SCHEMA/PASSWORD@INSTANCE @C:\script.sql

The above works fine for a single script, however I'd like to execute multiple scripts through one batch file. I've tried:

SQLPLUS SCHEMA/PASSWORD@INSTANCE @C:\script1.sql @C:\script2.sql

and

SQLPLUS SCHEMA/PASSWORD@INSTANCE @C:\script1.sql
exit
SQLPLUS SCHEMA/PASSWORD@INSTANCE @C:\script2.sql
exit

But neither seems to work. Is there any way I can avoid using multiple batch files?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros