Re: NLS_LANG and language of ORA-[xxxxx]

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 23 Jun 2004 21:50:07 -0700
Message-ID: <42fc55dc.0406232050.2f1570e2_at_posting.google.com>


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.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
Received on Thu Jun 24 2004 - 06:50:07 CEST

Original text of this message