Modified Parameter NLS_CALENDAR Of The Database Is Ignored By APEX Application (Doc ID 1634067.1)

Last updated on FEBRUARY 09, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.2.2 and later
Information in this document applies to any platform.

Goal

How to force APEX to use the  NLS_SESSION_PARAMETERS instead of the NLS_DATABASE_PARAMETERS.  Oracle 11g R2 database was installed with the parameter NLS_CALENDAR=PERSIAN.