Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlloader rejecting number
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
>>convert to a number using to_number, I get invalid number error from >>oracle. How can I resolve this ? >> >>Any help is appreciated >> >>Vissu
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 BortelReceived on Tue Apr 12 2005 - 04:04:33 CDT