Re: NLS_LANG
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 27 May 2009 20:35:37 +0200
Message-ID: <4A1D87F9.6070401_at_gmail.com>
Date: Wed, 27 May 2009 20:35:37 +0200
Message-ID: <4A1D87F9.6070401_at_gmail.com>
[Quoted] Gerard H. Pille schrieb:
> Is there any way to determine the NLS_LANG of a client using SQL or PL/SQL.
>
> sys_context('USERENV','LANGUAGE') gives the database characterset, not
> the clients.
>
> Thanks,
>
> Gerard
[Quoted] For local connections ( also using bequeth protocol) you can get the environment variables with dbms_system.get_env procedure.
Best regards
Maxim
-- Why make things difficult, when it is possible to make them cryptic and totally illogical, with just a little bit more effort? Aksel Peter JørgensenReceived on Wed May 27 2009 - 20:35:37 CEST