423,867 Members | 3,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,867 IT Pros & Developers. It's quick & easy.

NLS_LANG and language of ORA-[xxxxx]

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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).

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

Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

P: n/a
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.