The oerr script will use the oraus.msg file.
However, Oracle kernel will still use oraus.msb file that is a binay version
of the msg file.
Oracle does not give you any tool to convert your customized msg to msb.
But, that's where the fun begins ;) ( I have played with this thing in my
own TEST database. Yes, I said... TEST )
Here is how :
SQL> select * from mytable;
select * from mytable
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> !oerr ora 942
00942, 00000, "Do you think this table or view exists? "
// *Cause: It could be a typo.
// *Action: Learn to type correctly.
TGIF... :)
Cheers!
- Kirti
> -----Original Message-----
> From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 07, 2001 9:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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:[EMAIL PROTECTED]>]
> > 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" <[EMAIL PROTECTED]>
> > 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: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
