How to Set NLS Parameters at DAD Level for MOD_PLSQL (Doc ID 186775.1)

Last updated on APRIL 09, 2024

Applies to:

Goal

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

Solution