| sqlldr exit codes on NT [message #367933] |
Thu, 04 May 2000 16:45 |
Vasu Bhandarkar
Messages: 1
Registered: May 2000
|
Junior Member |
|
|
Hello,
I was wondering if anyone knows how to check the exit codes of SQLLDR from withing of a DOS batch file on NT 4.0.
I invoke sqlldr from within a batch file using:
sqlldr scott/tiger control=test.ctl data=test.dat log=test.log direct=yes
IF ERRORLEVEL 1 goto error
.
.
:error
.
.
For some reason, the ERRORLEVEL is always 0, even if the load did not work (data file not found, syntax errors in the control file, or the file had discards and rejects). The Oracle documentation mentions exit codes such as EX_FAIL and EX_WARN, and equates them to errorlevels 1, 2 etc. on unix. How do I get these exit codes in NT?
I'm using Oracle 8.1.5 on NT 4.0. Any help would be greatly appreciated.
Thanks in advance,
Vasu Bhandarkar
vasub@yahoo.com
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
