Hello!
I have an app that's in German (primary language) and has an English translation.
The English app is supposed to have the same group separator and decimal character as the German app. The nls_currency should be €. I used the Initialization PL/SQL Code in the Security Attributes to override the default nls settings:
execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = '',.''';
execute immediate 'ALTER SESSION SET NLS_CURRENCY = ''€''';
If I set only the currency, this method works perfectly fine. But as soon as I set the nls_numeric_characters to ",." I get the following error:
ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "APEX_220200.WWV_FLOW_SECURITY", line 2440 ORA-06512: at "APEX_220200.WWV_FLOW_AUTHORIZATION", line 640
Is there any way that I can have an English app but with my “German” numeric character settings?
Thank you for your help!
Patrizia