Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Checking exit codes of SQLLDR80 on NT

Checking exit codes of SQLLDR80 on NT

From: Dbutler <dbutlerNOmcSPAM_at_sprinc.com>
Date: Wed, 18 Aug 1999 22:32:30 +1700
Message-ID: <09920fb9.4e2dab95@usw-ex0107-052.remarq.com>


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

Received on Wed Aug 18 1999 - 00:32:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US