sqlldr 'NULL date'

[naushi]

I am trying to load data into a table using sqlldr. everything works fine but the records with NULL date do not get loaded and they appear in the bad file.

I am using 'trailing nullcols' in my load statement. I am also using NULL if ... = blanks. default if ...= blanks

The column in the table allows NULL in the date column.

I am puzzled why null dates are being rejected.

Regards,
Naushi Hussain
Naushi.hussain@honeywell.com