Date picker and russian language on Oracle 9.2 database
Hi.
I have a problem with a date picker when APEX installed on Oracle 9.2 database. When I set primary application language to English, French, or another, but Russian (or similar Belorusian), the date picker work fine. But when I set primary language to Russian or another language with the same NLS Territory, date picker's popup window contain HTML 404 error's page.
My researches lead me to the table flows_020200.wwv_flow_languages, which contains all language parameters. For Russian language it contain NLS_TERRITORY "RUSSIA". But there is not RUSSIA territory in Oracle 9.2! There is CIS territory.
So my decision is simple:
update flows_020200.wwv_flow_languages
set NLS_TERRITORY = 'CIS'
where NLS_TERRITORY = 'RUSSIA';
commit;
and all problems are go away.
Dmitry