Bad decimal character in loading a flat file into an Oracle table

[pazou]

Hi all,

I am trying to load an Oracle table from a flat file via SQLLDR (Sql*Loader).
The decimal character used in the flat file is "." and the decimal character in the database is ",".

The loading failed because of the invalid format in the flat file.

How to proceed?

Thanks in advance for your help.

Pazou

 

[sem]

You may change your NLS_NUMERIC_CHARACTERS environment variable. The issue is not that your database uses ",", but rather that your Oracle client (due to NLS_LANG) does this.

Regards, Dima

http://seminihin.narod.ru

 

[KenCunningham]

Or change the decimal character in the flat file before loading?