Forum Stats

  • 3,770,159 Users
  • 2,253,079 Discussions
  • 7,875,349 Comments

Discussions

Decimal separator stop working

Hello,

My application is showing "NaN" for my number fields since last week. I've realised that it doesn' t accept anymore a comma as a decimal separator.

If I click on the field it shows the number properly

Here are the format mask that I'm using.

I've tried to change it to 999G999G999G990 without decimal places and it shows the numbers with the dot separator for the thousands, which is correct.

However, if I change the application language to english and it shows the number properly.

I've also tried to force the database NLS_NUMERIC_CHARACTERS = ',.' with the Initialization PL/SQL Code at the database session but it didn't work either.


Thanks

Tagged:

Best Answer

Answers