APEX

Hello,

I created an APEX application in the Hungarian language, and later translated it to English. I could translate every text in the application, but now I'm facing a problem concerning the NLS_TERRITORY setting.

There's a point in the program logic where i need to look through the days of a given week. In the English version of the application, I found out that weeks start on Sunday and end on Saturday. This means that for a Hungarian-speaking user a given week consists of different days than for an English-speaking user, which unfortunately is not acceptable.

My question is: is there a way to override APEX's choice of NLS_TERRITORY setting in a translated application?

I read through the threads in this topic, tried to put

EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TERRITORY="HUNGARY"';

in a Virtual Private Database (VPD) call under Security atrributes, and also tried defining a Before-Header Application Process with the same command. But these attempts resulted in an errorous translated application, either the pages displayed incorretly (with any kind of design or images (???) ) or simply received "Page not found" error.

Any help regarding this problem would be much appreciated.

Denes Toth