-
Please Help!... How can i gen english Oracle Error Messages?
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
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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 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
-
Code:
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
-
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.-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|