470,638 Members | 1,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

NLS_LANG and language of ORA-[xxxxx]

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
3 22562
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
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
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.

Similar topics

1 post views Thread by Adam Ruth | last post: by
6 posts views Thread by bdj | last post: by
reply views Thread by basmgokul | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.