Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlloader rejecting number

Re: sqlloader rejecting number

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 12 Apr 2005 11:04:33 +0200
Message-ID: <d3g2og$aef$2@news4.zwoll1.ov.home.nl>


fitzjarrell_at_cox.net wrote:
> viss..._at_yahoo.com wrote:
>

>>Hi,
>>
>>I have a field in csv file that I intend to load into number column.
>>The csv field contains all numeric but sqlloader is rejecting data.
>>Data loads if I declare the column as varchar2.  But then when I try

>
> to
>
>>convert to a number using to_number, I get invalid number error from
>>oracle. How can I resolve this ?
>>
>>Any help is appreciated
>>
>>Vissu

>
>
> obviously this value is NOT a number, else Oracle would accept it with
> SQL*Loader and you'd be finished. Of course posting the errant loader
> records completely slipped your mind, apparently. And, drat, my
> crystal ball is AGAIN in the shop for repairs. I just can't keep the
> damned thing running ...
>

You're better off than me - I dropped mine :(

> You have an answer commensurate with your provided information.
> Provide more, receive more.
>

OK - one wild guess: could NLS_NUMERIC_CHARACTERS be a problem?

-- 
Regards,
Frank van Bortel
Received on Tue Apr 12 2005 - 04:04:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US