Re: NLS_LANG in procedures?

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 12 Oct 1999 18:10:10 +0200
Message-ID: <7tvmjf$fot$1@oceanite.cybercable.fr>

You can check v$nls_parameters or nls_session_parameters view in your stored procedure:

v734> select value from v$nls_parameters where parameter='NLS_LANGUAGE';

VALUE

---

AMERICAN 1 row selected.

v734> select value from nls_session_parameters where parameter='NLS_LANGUAGE';

VALUE

---

AMERICAN 1 row selected.

--
Regards

Michel

Frederic Galot <fgalot_at_x-lan.com> a écrit dans le message : jyIM3.269$_e7.911511_at_nnrp1.proxad.net...
> I would like to localize an application. I've got the idea that I could
> use the NLS_LANG of the client session to modify the result of some stored
> procedures.
> I think I could make a test in the procedure like :
> if (client.NLS_LANG==FRENCH_FRANCE.etc...)then
> -- here a french message
> else....
>
> Has anyone ever done that or has another idea?
> thanks for help.
>
> fgalot_at_x-lan.com
>
>
Received on Tue Oct 12 1999 - 11:10:10 CDT