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 [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

   Oracle Application Server Globalization Support Guide 10g Release 2 (10.1.2)

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.