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 is not a number, else ORacle would have taken it as such and you'd be done. Posting the errant records was, apparently, not necessary. Unfortunately my crystal ball is still in the shop.
You have an answer commensurate with the information you supplied. Provide more, receive more.
David Fitzjarrell Received on Mon Apr 11 2005 - 22:15:22 CDT