Modified Parameter NLS_CALENDAR Of The Database Is Ignored By APEX Application
(Doc ID 1634067.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Application Express (formerly HTML DB) - Version 4.2.2 and later
Information in this document applies to any platform.
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.
- In SQL Workshop issue the following command:
The result returned is not Gregorian, instead the result returned is the NLS_DATABASE_PARAMETERS value - Persian in this case.
When you run the same steps in SQLPlus returns GREGORIAN / NLS_SESSION_PARAMETER value instead of the NLS_CALENDAR / NLS_DATABASE_PARAMETERS value returned in SQL Workshop.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.