Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to change error messages?

RE: How to change error messages?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 06 Sep 2001 17:52:23 -0700
Message-ID: <F001.00386070.20010906174525@fatcity.com>

> -----Original Message-----
> From: Terrian, Tom [mailto:tterrian_at_daas.dla.mil]
>
> Does anyone know how to change the message that Oracle
> displays when an error
> occurs.  For example:
>
> SQL> select * from fjfjfjfjf;
> select * from fjfjfjfjf

>               *

> ERROR at line 1:
> ORA-00942: table or view does not exist
>
> I am sure that Oracle Corp. will really frown on this, but
> can I change "table
> or view does not exist" to something else?

If you're bored with seeing the same old error messages, have you tried spicing up your life by installing Oracle in a different language?

SQL> select * from fjfjfjfjf;
select * from fjfjfjfjf
              *
ERREUR à la ligne 1 :
ORA-00942: Table ou vue inexistante

Otherwise, like someone else suggested, you can have a EXCEPTION clause in a PL/SQL block to catch the error and display a different message, but that won't change the "default" error message. Received on Thu Sep 06 2001 - 19:52:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US