Oracle Enterprise Stage SQLLOADER issue

[jaganmo]

When Blank is supplied for a Column F1 which is of Char 1, the Oracle Enterprise Stage treats that as a NULL and rejects. This happens only when the Write Method is Load.

Any suggestions to avoid the rejection of records with column having space.

[betterthanever]

any warnings in the log???

[chulett]

There should be an APT variable to "preserve blanks" from what I recall. Ah, yes, found it - set $APT_ORACLE_PRESERVE_BLANKS to TRUE.

[jaganmo]

There should be an APT variable to "preserve blanks" from what I recall. Ah, yes, found it - set $APT_ORACLE_PRESERVE_BLANKS to TRUE. ...

Thanks Everybody.

Using $APT_ORACLE_PRESERVE_BLANKS to True, I could successfully load the data.