Re: sqlloader rejecting number

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Tue, 12 Apr 2005 22:54:38 +0200
Message-ID: <89do51lsat70jt40s3d4dpha7p7tac54ah@4ax.com>

On 11 Apr 2005 18:36:37 -0700, vissuyk_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

Please post the output of the following query:

select dump(<varchar2 field name>) from table

for the relevant record.

Jaap. Received on Tue Apr 12 2005 - 15:54:38 CDT