My Oracle Support Banner

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.

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

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.