am********@gmx.at (Michael John) wrote in message news:<8d*************************@posting.google.c om>...
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