Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A question about error message
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_at_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_at_mail.pouchen.com.tw,Thanks :)
>
>Violin
Received on Wed Sep 09 1998 - 04:51:46 CDT