Re: Running SQLPlus from command line

Thank you for the links to the syntax.

Here are the 8 lines (simplified).
Right now, line 3 runs fine and connects. Lines 4 thru 8 do not run at all unless I do these manually. I need these to run as a batch process from start to finish. Lines 4 thru 8 are outside of the SQL Plus environment in this batch process. How do I 'include' lines 4 thru 8 so that they run in succession automatically  with no manual intervention?

Startup and display SQL file that is running... 1. @echo off
2. echo Running TEST12.SQL

connect to Oracle...
3. SQLPLUS -s myUserID/myPass_at_myDBName

Get the SQL file into the buffer...
4. GET TEST12.SQL Run the SQL file....
5 . RUN Spool the output to .txt file...
6. SPOOL TEST12.txt

Turn off spooling...
7. SPOOL OFF Exit SQL Plus....
8. EXIT What am I missing here? Received on Wed Oct 11 2006 - 13:01:38 CDT