Re: Error on SQL Loader
Date: 21 Oct 2002 09:09:07 -0700
Message-ID: <336da121.0210210809.5242df6b_at_posting.google.com>
"IQ" <iq1969_at_libero.it> wrote in message news:<gjOs9.57557$%M1.1481777_at_twister2.libero.it>...
> Hi,
> i have a problem loading a txt file, numeric fields, with SQL Loader.
> I have italian settings, "," is decimal separator and "." is thousands
> separator.
> The TXT file is setting in this way : "12345.89".
> Oracle returns this error : "ORA-01722", invalid numeric field.
> I try to change windows setting, forced some environment variables and so
> on...
>
> Sorry for my english, and someone help me please...
>
> Bye
Try to set explicit format for this field. You can also change your
decimal separator and thousands separator settings in registry, but it
may be wrong for
other Oracle applications.
Received on Mon Oct 21 2002 - 18:09:07 CEST