Hi
I have a page with IR that displays some lines with the name and amount. Application in Russian,
Application Primary Language = Russian (Ru),
Application Language Derived From = Application Primary Language.
Also, in the Security settings in the Initialization PL / SQL Code it is written
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS =''. ''';
END;
since in the application, the number format should be exactly like '123 456.78'.
After switching from APEX 5.0 to APEX 19.2, a problem appeared.
When trying to filter on a sum column with a decimal separator value, IR shows an
ORA-06502: PL / SQL:: numeric or value error: character to number conversion error
In the debug, you can see that it is first installed
alter session set NLS_COMP = 'BINARY' NLS_SORT = 'BINARY' NLS_CALENDAR = 'GREGORIAN' NLS_TERRITORY = 'AMERICA' NLS_LANGUAGE = 'AMERICAN'
then
alter session set nls_language = 'RUSSIAN' nls_territory = 'RUSSIA'
where
... NLS: Set Decimal separator = ","
and
... NLS: Set NLS Group separator = ""
Then it starts
begin BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS =''. ''';
END;
And when trying to install the filter, an error is returned
ORA-06512: on "APEX_190200.WWV_FLOW_IR_RENDER", line 4887
ORA-06512: on "APEX_190200.WWV_FLOW_IR_RENDER", line 4887
ORA-06512: to "APEX_190200.WWV_FLOW_IR_RENDER", line 6619
Backtrace: ORA-06512: to "APEX_190200.WWV_FLOW_IR_RENDER", line 4887
ORA-06512: on "APEX_190200.WWV_FLOW_IR_RENDER", line 4887
ORA-06512: to "APEX_190200.WWV_FLOW_IR_RENDER", line 6619
ORA-06512: to "APEX_190200.WWV_FLOW_IR_RENDER", line 12889
If the globalization settings are configured as in this discussion, then this problem disappears, but at the same time if you upload IR to CSV, then the file unloads the i character instead of the Cyrillic letters.
There was no such error in APEX 5.0 and 5.1.
I ask for your help.