October 15th, 2003, 11:42 AM
Join Date: Sep 2003
Time spent in forums: 2 h 6 m 51 sec
Reputation Power: 0
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.