Dear all,
I ran into a problem where a decimal separator (comma) is being completely removed from a numeric value during automatic row processing, for example saving "3,1" as "31" in the database table.
In my application I need to use comma(,) as a decimal separator. So first I do ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ', '; during database session initialization.
Here is a sample app.
If you try to create a new record with some decimal value ( 3,14) comma will be gone with no warning.
https://apex.oracle.com/pls/apex/f?p=50030:3
User: demo
Pswd: demo123
Do you happen to know any workaround for this?
Janis