| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Checking exit codes of SQLLDR80 on NT
Hi all,
I'm having a difficult time checking the exit codes of SQLLDR80 inside of a command file on NT 4.0.
I have two lines inside a command file similar to the following:
sqlldr80 scott/tiger_at_instance control=appl.ctl log=appl.log
IF %ERRORLEVEL% == 0 goto goodload
.
.
Do some commands to handle a bad load here
.
.
:goodload
The problem is, even if the load did not work (syntax errors in the control file, or the file had discards and rejects) the ERRORLEVEL always is 0. The Oracle documentation mentions exit codes such as EX_SUCC and EX_WARN, are these just error level's 1 and 2 respectively? Am I going about this the right way?
Any help anyone can give me would be greatly appreciated. I'm running Oracle 8.0.5 Enterprise on NT 4.0 SP4 by the way.
Thanks in advance,
Dwayne
![]() |
![]() |