Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlloader rejecting number
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 have an answer commensurate with your provided information. Provide more, receive more.
David Fitzjarrell Received on Mon Apr 11 2005 - 23:09:21 CDT