Hello
I am trying to change the decimal separator from a comma to a period in a translated French application (fr-ca).
I am using the following code in an application process On Load: Before Header:
DBMS_SESSION.SET_NLS('NLS_NUMERIC_CHARACTERS', '''.,''');
However, I receive an error when running the French version of the application (see image below).
Does anyone have an idea of how I can resolve this issue?
Note: It works correctly when French is set as the application’s primary language, but not when it is a translated application.
Apex Version: 24.1.3
I have also tried in Apex Oracle Cloud (v.24.2.8) and I got the same results. I wonder if this is a bug and I would like to know if there is a workaround for this issue.
