sqlloader rejecting number

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 Received on Mon Apr 11 2005 - 20:36:37 CDT