Please Help!... How can i gen english Oracle Error Messages?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Question 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

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  4. #4
    Join Date
    Jul 2003
    Posts
    5
    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.

  5. #5
    Join Date
    Jul 2003
    Posts
    5

    Question

    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  7. #7
    Join Date
    Jul 2003
    Posts
    5
    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

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look in regdit


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

  9. #9
    Join Date
    Jul 2003
    Posts
    5
    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
  •  


Click Here to Expand Forum to Full Width