Modified Parameter NLS_CALENDAR Of The Database Is Ignored By APEX Application
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.
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.
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 hundreds of Community platforms