Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to change error messages?
> -----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
> *
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