Please Help!... How can i gen english Oracle Error Messages?

[maite]

How can I change Oracle error message to English??, I am getting the oracle error in Dutch.

Example:

FOUT in regel 1:
.ORA-01400: Kan geen NULL invoegen in ("ORADESA"."EMP"."DEPT_ID").
ORA-06512: in "ORADESA.NEWEMP", regel 29

I can not find any information about, if somebody know, please help me.

Thanks

Maite

[jovery]

The error you are encountering is trying to insert a null value into a NOT NULL column.

If you need access to the error descriptions use

http://otn.oracle.com/pls/db92/db92....e&prefill=ORA-

Regards

[pando]

change your NLS_LANG to AMERICAN_AMERICA.CHARACTERSET

oerr is a shell script which reads $ORACLE_HOME/rdbms/mesg/$LANG.msg and tells you the error message

oerr ora 942 for example

[maite]

Hi jovery,

Thank for your quick answer.

I know how to look for the error description but I like to get the english error message because I can work easy and faster. I have expirience working with oracle so if I read a error message I know most of the time what to do, but in ducht take to long to resolve a error, special if i get error after error.

Best Regards,

Maite.

[maite]

Hello Pando,

About changing the NLS_LANG to AMERICAN_AMERICA.CHARACTERSET, this is what I have. Where I need to change the NLS_LANG?

1* select * from nls_database_parameters
SQL> /

PARAMETER VALUE
------------------------------ -------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSX
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSX
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0

20 rijen zijn geselecteerd.

Thanks,
Maite

[pando]

SSESMADT001:oracleuser:e73gc04:/home/tdata/oracleuser> echo $NLS_LANG
SPANISH_SPAIN.WE8ISO8859P1
SSESMADT001:oracleuser:e73gc04:/home/tdata/oracleuser> sqlplus /

SQL*Plus: Release 3.3.4.0.1 - Production on Wed Jul 16 12:46:06 2003

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Conectado a:
Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.5.0 - Production

SQL-SSESMADT001-E73GC04>select * from x;
select * from x
              *
ERROR en lÃ*nea 1:
ORA-00942: la tabla o vista no existe


SQL-SSESMADT001-E73GC04>quit
Desconectado de Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.5.0 - Production
SSESMADT001:oracleuser:e73gc04:/home/tdata/oracleuser> export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
SSESMADT001:oracleuser:e73gc04:/home/tdata/oracleuser> sqlplus /

SQL*Plus: Release 3.3.4.0.1 - Production on Wed Jul 16 12:46:22 2003

Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.


Connected to:
Oracle7 Server Release 7.3.4.5.0 - Production
With the distributed, replication and parallel query options
PL/SQL Release 2.3.4.5.0 - Production

SQL-SSESMADT001-E73GC04>select * from x;
select * from x
              *
ERROR at line 1:
ORA-00942: table or view does not exist

it´s environment variable

[maite]

Pando,

I forgot to mention before I am working with Windows 2000.
Is NLS_LANG Operation System environment variable? your example is a Unix O.S.?

regards,

Maite

[pando]

look in regdit


HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0 if you have one ORACLE_HOME

[maite]

Pando,

Thanks you very much,

Now I get english error message.

Maite.-