Error on SQL Loader
From: IQ <iq1969_at_libero.it>
Date: Mon, 21 Oct 2002 07:48:28 GMT
Message-ID: <gjOs9.57557$%M1.1481777_at_twister2.libero.it>
Hi,
[Quoted] [Quoted] 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...
Date: Mon, 21 Oct 2002 07:48:28 GMT
Message-ID: <gjOs9.57557$%M1.1481777_at_twister2.libero.it>
Hi,
[Quoted] [Quoted] 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 Received on Mon Oct 21 2002 - 09:48:28 CEST