Hi all,
I have a problem with setting correct numeric group separator - thousand separator character should be space (not dot as is "preset" in Oracle).
SELECT * FROM V$NLS_PARAMETERS returns
NLS_LANGUAGE CZECH
NLS_NUMERIC_CHARACTERS ,.
In other applications I can simply deal with it by changing NLS_NUMERIC_CHARACTERS manually right after login and the setting persists. So I tried the same approach in APEX and created an application process
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS='', ''';
which is triggered on every page on load before header and numbers are displayed correctly. So far so good.
The problem is that after any change on a report (both classic and interactive like column sorting, filtering...whatever) this setting is forgotten and thousand/group separator is reverted to "dot".
Any ideas how to persistently set NLS_NUMERIC_CHARACTERS would be highly appreciated.
Thanks in advance,
Pavel