Xref: alice comp.databases.oracle.misc:19685
Path: alice!news-feed.fnsi.net!nntp.msen.com!news.altair.com!NewsNG.Chicago.Qual.Net!newsgate.mot.com!newshost.mot.com!schbbs.mot.com!not-for-mail
From: "Alan D. Mills" <alanmNOSPAM@uk.europe.mcd.mot.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: A question about error message
Date: Wed, 9 Sep 1998 10:51:46 +0100
Organization: Motorola Inc.
Lines: 54
Message-ID: <6t5j2g$cje$1@schbbs.mot.com>
References: <35fa3f14.31183001@news.twsc.pouchen.com.tw>
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4

You didn't mention your platform of installation.  We have Oracle installed
on AIX and this gives us a command line program to look up Oracle errors


e.g.  I would use

%oerr ora 2298
 to give the response

02298, 00000,"cannot enable constraint (%s.%s) - parent keys not found"
// *Cause: an alter table enable constraint fialed because the table has
//      orphaned child records.
// *Action: Obvious


and

%oerr ora 933

to give

00933, 00000, "SQL command not properly ended"
// *Cause:
// *Action:

As you can see the responses are not always as helpful as you might like but
it does save trawling through a manual of error messages.

The first parameter to oerr is the message type.  Presumablky it works for
other types than ORA but that's all I use it for.  The last parameter is the
message number with no '-' (minus) sign.

Don't know if this will help but...


--
Alan D. Mills


Violin wrote in message <35fa3f14.31183001@news.twsc.pouchen.com.tw>...
>Hello,
>I'm wondering if it's available.
>'Cause I don't have the handbook for all the SQL error,
>and PLS/SQL error:
>like ora-02298,ora-00933,pls-06601.....
>I want to know if there is any  www-site for searching error messages
>and the error solution.
>If you know,please tell me.
>Thank you in advance.
>Please Cc to : violin.hsiao@mail.pouchen.com.tw,Thanks :)
>
>Violin