How to Set NLS Parameters at DAD Level for MOD_PLSQL
(Doc ID 186775.1)
Last updated on APRIL 07, 2022
Applies to:Oracle HTTP Server - Version 1.0.2 to 10.1.3.0.0 [Release 9iAS to AS10gR3]
Information in this document applies to any platform.
The purpose of this document is to provide simple step-by-step instructions on setting NLS parameters at the DAD level for mod_plsql. This bulletin is useful for anyone trying to setup different National Language Support (NLS) parameters for different DADs. NLS is explained in more detail in the following documentation: (Using Oracle Database 10.1, as an example) Oracle Database Globalization Support Guide 10g Release 1 (10.1) Character Sets https://download.oracle.com/docs/cd/B14117_01/server.101/b10749/applocaledata.htm#sthref1719 and Oracle Application Server Globalization Support Guide 10g Release 2 (10.1.2) https://download.oracle.com/docs/cd/B14099_19/core.1012/b14004/toc.htm For PL/SQL Gateway (mod_plsql), the National Language Support variables (NLS_LANGUAGE, NLS_TERRITORY and NLS_CHARACTERSET) can be set either as an environment variable or at the mod_plsql DAD level, which should compatible with whats set in the database: > sqlplus system<password> SQL> select * from nls_database_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET'); ** Part 1 of this article explains how to set up mod_plsql for your NLS However, for other NLS variables(NLS_SORT, NLS_DATE_FORMAT, etc.) there is no direct support in mod_plsql. This article provides the recommended method when using these special NLS variables. ** Part 2 of this article explains how to setup and use these NLS variables. ** Part 3 of this article provides a sample to test NLS variables in mod_plsql
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!