Printable View
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
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
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
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 :confused: take to long to resolve a error, special if i get error after error.
Best Regards,
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
it´s environment variableCode: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
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
look in regdit
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0 if you have one ORACLE_HOME
Pando,
Thanks you very much,
Now I get english error message.
Maite.-