No, I set the NLS Options while starting the import with
NLS_NUMERIC_CHARACTERS=",."; export NLS_NUMERIC_CHARACTERS;

In some cases the positive numbers are loaded, but not the negative ones.

ana said the following on 09.12.2004 18:36:
> "Ralf Bender" <ralf.bender@arcor.de> wrote in message
> news:41b87c71$0$16034$9b4e6d93@newsread4.arcor-online.net...
>
>>Hello
>>
>>I've got a big flat file with # as separator.
>>There is a number field which has negative sign at the end or nothing if
>>it is a positive number:
>>
>>D#100,00#100,00#BET
>>S#100,00-#100,00-#WISH
>>
>>In the database the field is a number(15,2)
>>
>>I try to load this file with sql-loader, but earn always errors like
>>invalid number ...
>>
>>I try (seen at ask tom)
>>column_name "to_number( :column_name, '9999999999s' )/100",
>>or
>>column_name "to_number( :column_name, '99999999D99MI' )",
>>
>>nothing works correctly. In some cases i got the positive numbers but
>>not the negative ones.
>>
>>Is there someone who can help me to climb this little rock?
>>
>>thanks
>>ralf
>
>
> It might be choking on the commas due to NLS incompatibility
>
>