Re: NLS_LANG and language of ORA-[xxxxx]

amstelchen_at_gmx.at (Michael John) wrote in message news:<8dbd6a8d.0406230202.ac0ccf7_at_posting.google.com>...
> Hey,
>
> how can I get ORA-..... error messages in languages other than
> english.
> I did a
> alter session set NLS_LANG='GERMAN_GERMANY.WE8ISO8859P1';
> but this only threw an ORA-00922.
>
> Or I'm wrong and NLS_LANGUAGE and NLS_TERRITORY doesn't have an effect
> on the text of ORA- error messages at all?
>
> Any hints?
> TIA,
> mic

NLS_LANG and NLS_LANGUAGE are 2 different things (as documented). NLS_LANG can be set as environment variable (Unix) or registry variable (Winblows) only, it can't be set using ALTER SESSION. NLS_LANGUAGE can be set using ALTER SESSION and will impact the error messages.
Prerequisites are
- you actually did install the message libraries, choosing at least 2 languages during installation
- ORA_NLS33 has been set

Other than that: no joy

Please also read up on NLS in the NLS doco.

Sybrand Bakker
Senior Oracle DBA Received on Thu Jun 24 2004 - 09:57:19 CEST