Hi friends ,

can i capture sqlldr error message or exception when sqlldr gets some bad records

actually we are invoking this in shell script .

sqlldr xyz/xyz@test control=/usr/local/weblogic/upload_vol.ctl direct=true log=/usr/local/weblogic/upload_vol.log

--- upload_vol control file

LOAD DATA
INFILE '$FILE_NM'
INTO TABLE upload_volume
TRUNCATE
FIELDS TERMINATED BY ','

Thanks in advance .