Page 1 of 1
Oracle Enterprise Stage SQLLOADER issue
Posted: Mon Feb 09, 2009 1:19 pm
by 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.
Re: Oracle Enterprise Stage SQLLOADER issue
Posted: Mon Feb 09, 2009 1:22 pm
by betterthanever
any warnings in the log???
Posted: Mon Feb 09, 2009 1:23 pm
by 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.
Posted: Mon Feb 09, 2009 1:43 pm
by jaganmo
chulett wrote: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.