SQL Loader (sqlldr) Exit Codes

新旧版本不一样

如果你需要调用sqllder并判断exit code。
那么请小心Unix和Windows不一样。
更要注意Oracle的版本，各个版本在Windows下并不是一样的。

返回4种情况：

EX_SUCC ：All rows loaded successfully
EX_WARN ：All or some rows rejected
EX_WARN ：All or some rows discarded
EX_WARN ：Discontinued load
EX_FAIL ：Command-line or syntax errors
EX_FAIL ：Oracle errors nonrecoverable for SQL*Loader
EX_FTL ：Operating system errors (such as file open/close and malloc)

Oracle 9i

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

Oracle 11g & 12c & 19c

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_FAIL 1
EX_WARN 2
EX_FTL 4