October 14th, 2003, 05:28 PM
Return code (Success or Fail) of sqlldr
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.
October 15th, 2003, 09:13 AM
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.
October 15th, 2003, 10:42 AM
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
All or some rows rejected
All or some rows discarded
Command-line or syntax errors
Oracle errors nonrecoverable for SQL*Loader
Operating system errors (such as file open/close and malloc)
For UNIX, the exit codes are as follows:
For Windows NT, the exit codes are as follows:
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.
September 12th, 2014, 12:28 AM
Return code of sqlldr is 0,1,2,3,127
Any return code other than 0 is failure and 0 is success
and 127 is syntax error or wrong command