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

Even just "ALTER SESSION SET NLS_LANGUAGE = GERMAN;" should accomplish
this.
But check if you have the necessary mesg files first. (I think you
need ORAD.MSB at least).

amstelchen (AT) gmx (DOT) at (Michael John) wrote in message news:<8dbd6a8d.0406230202.ac0ccf7 (AT) posting (DOT) google.com>...

amstelchen (AT) gmx (DOT) at (Michael John) wrote in message news:<8dbd6a8d.0406230202.ac0ccf7 (AT) posting (DOT) google.com>...
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

Hello Romeo
hello Sybrand,

thanks very much for your assistance. I will have to contact my local
IT staff to install necessary message files on server side.

cheers,
mic