Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to change error messages?
under $ORACLE_HOME/rdbms/mesg
there are many error messages files.
the ones your looking for here are
oraus.msg
oraus.msb
The extention msg files are ascii text that you can edit if you like (I used to do this a lot on Oracle 6 and 7), but unless they have changed things since then, these files are used only by the oerr utility.
The msb files are binary files that are used by the executables to look up error messages.
BTW, the 'us' in the file name indicates us english. If you are working with some other language, it will be oraXX.msg, where XX indicates the language of the file.
> -----Original Message-----
> From: Scott Shafer [mailto:sknd100_at_yahoo.com]
> Sent: Thursday, September 06, 2001 7:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: How to change error messages?
>
>
> Trying to remember here, but isn't there a file called "oraus.mesg" or
> something similiar somewhere under your $oracle_home that
> contains all the
> messages and events? Edit the message you want. Do not tell
> Oracle Corp.
> you did this. I have not done and definitely do not
> recommend doing it
> unless its on a "play" system. This has fun possibilities
> when I think
> about certain duhvelopers... Hmmm...
>
> Scott Shafer
> San Antonio, TX
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, September 06, 2001 4:18 PM
>
>
> > I don't know about SQLPLUS, but you sure can do it in
> pl/sql. You can
> > manipulate it in EXCEPTION clause.
> >
> > HTH
> > Raj
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Shafer
> INET: sknd100_at_yahoo.com