Re: sqlldr problem

Hi

No, it is not a bug...
[Quoted] You can Use NULLIF to load a blank field as null:

For instance:

FieldName CHAR(20) NULLIF (FieldName)=BLANKS OR
FieldName CHAR(20) NULLIF (FieldName)=" "

rgrds
Kari Pannila
Oracle DBA (OCP)

PS. Delete X from my mail address , it (X) is only for SPAMMERS.

Johan den Boer wrote:
>
> Hi,
>
> I am trying to load data in a table with sqlldr. If I have fields
> between two | seperators and it is a space the field will
> not be loaded ( like | space | ). Is this a bug in sqlldr. There
> are no constraints on that feld.
>
> --
>
> regards
>
> Johan den Boer
> e-mail : jj.den.boer_at_hccnet.nl

--