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_FAIL

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

load data
infile *
into table test_tab
when col1='1'
fields terminated by ','
(col1 position(1), col2)
into table test_tab
when col1='2'
fields terminated by ','
(col1 position(1), col3)
begindata
1,a,
2,b,

SCOTT@orcl_11gR2> create table test_tab
  2    (col1  number,
  3  	col2  varchar2 (4),
  4  	col3  varchar2 (4))
  5  /

Table created.

SCOTT@orcl_11gR2> host sqlldr scott/tiger control=test.ctl log=test.log

SCOTT@orcl_11gR2> select * from test_tab
  2  /

      COL1 COL2 COL3
---------- ---- ----
         1 a
         2      b

2 rows selected.

SCOTT@orcl_11gR2>

SQL*Loader: Release 11.2.0.1.0 - Production on Fri Nov 11 10:35:25 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Control File:   test.ctl
Data File:      test.ctl
  Bad File:     test.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table TEST_TAB, loaded when COL1 = 0X31(character '1')
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
COL1                                    1     *   ,       CHARACTER            
COL2                                 NEXT     *   ,       CHARACTER            

Table TEST_TAB, loaded when COL1 = 0X32(character '2')
Insert option in effect for this table: INSERT

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
COL1                                    1     *   ,       CHARACTER            
COL3                                 NEXT     *   ,       CHARACTER            


Table TEST_TAB:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  1 Row not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Table TEST_TAB:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  1 Row not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                  66048 bytes(64 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:             2
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Fri Nov 11 10:35:25 2011
Run ended on Fri Nov 11 10:35:25 2011

Elapsed time was:     00:00:00.20
CPU time was:         00:00:00.00