> -----Original Message-----
> From: Terrian, Tom [mailto:[EMAIL PROTECTED]]
>
> 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.
