Return code (Success or Fail) of sqlldr

Hi,

I would like to know what will be the return code for the sql loader when there is rejection of single record from the data file.

Can someone please tell me regarding return code of sqlldr so that depending on that i would be able to take some action.

The other methods which are there to do the same :
1) To scan the log file and check for rejected keyword
2) To check weather any bad file is created.

Any help would be highly appreciated.

Thanks!!

I'm not aware of anything else besides the log file and the bad file. SQL*Loader, by nature, is a batch program, which is usually invoked by the operating system (i.e. cron job). So, it reports about its detections only via its own files.

Cheers,
Dan

hi,

Thanks for replying.
I got few things from the web.

Here are the exit codes return by the sqlldr for unix and windows nt respectively.

Result Exit Code
All rows loaded successfully
EX_SUCC

All or some rows rejected
EX_WARN

All or some rows discarded
EX_WARN

Discontinued load
EX_WARN

Command-line or syntax errors
EX_FAIL

Oracle errors nonrecoverable for SQL*Loader
EX_FAIL

Operating system errors (such as file open/close and malloc)
EX_FTL



For UNIX, the exit codes are as follows:

EX_SUCC 0
EX_FAIL 1
EX_WARN 2
EX_FTL 3


For Windows NT, the exit codes are as follows:

EX_SUCC 0
EX_WARN 2
EX_FAIL 3
EX_FTL 4


If SQL*Loader returns any exit code other than zero, you should consult your system log files and SQL*Loader log files for
more detailed diagnostic information.

I guess i would be able to do something with this.

Anyway thanks for replying.

Regards,