NLS_lang Parameter Differs

Srinivasjai — Wed, 09 Sep 2009 13:38:34 GMT

Hi,

When am query on server side the nls_lang is set to nls_language='american' but it differs in TOAD='United Kingdom'
The O/p as follows

1)SQL> select userenv('LANG') from dual;

USERENV('LANG')
----------------------------------------------------
US
2)SQL> select distinct language from fnd_lookup_values;
LANGUAGE
------------------------------
US
3)SQL> SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

But when am trying these Commands through TOAD.
1)select userenv('LANG') from dual;
USERENV('LANG')
--------------------------------
GB
2)SELECT * FROM NLS_SESSION_PARAMETERS;
PARAMETER VALUE
----------------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY UNITED KINGDOM
NLS_CURRENCY £
NLS_ISO_CURRENCY UNITED KINGDOM

Please can anyone help on this

~Srinivas

Re: NLS_lang Parameter Differs

Volker Borowski — Wed, 09 Sep 2009 15:55:22 GMT

When you run Toad in Windows, it is most likely, that it derives the locale either from the Windows regional Settings
(i.E. setting a german Keyboard and a german
dateformat on a English Windows Server makes
runInstaller present german text !)

or it is explicitly set environment on the client machine. Check by starting CMD.EXE and
execute
SET

to validate the environment on the client side. Check the client for the regional settings in the Windows Control Panel.

Volker

topic Re: NLS_lang Parameter Differs in Operating System - HP-UX

NLS_lang Parameter Differs

Re: NLS_lang Parameter Differs