Re: sqlldr problem

You should not have this problem unless to have a constraint on the field...I load many records with some blank values for various fields...Unless the field is set to a specific format ( like DATE 'MMDDYYYY' ) I have no problems...

Kari Pannila <Xkartsa_at_ougf.fi> wrote:

>Hi
>
>No, it is not a bug...
>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

[Quoted] -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Mar 14 2000 - 21:18:13 CET