HOW TO translate error messagesThis is a featured page

Platform: Oracle App: Application Object Library Tool:
DB Ver: 9.2 App Ver: 11.5.8 Tool Ver:
Revision Date: 10-Jul-2006 Keywords: HOWTO, ERROR MESSAGE,ORA, OERR

Goal
To get the explanation of an Oracle error message

Facts


Solution
Oracle reports errors in the same format across all its applications and products. The format is:

<3 character facilty>-<5 digit error number>

Example:

ORA-00100 no data found
PLS-00207 identifier 'string', applied to implicit cursor SQL
There are a number of ways of getting some additional detail on the given error message; here are a few of the ways

Unix Level oerr
This is a unix level utility that is available from the unix command prompt.

Usage: oerr facility error

Facility is identified by the three-letter prefix in the error
string. For example, if you get ORA-7300, "ora" is the facility
and "7300" is the error. So you should type "oerr ora 7300".
If you get LCD-111, type "oerr lcd 111", and so on.
Example

oerr ora 600

Website ora-code.com
This is also available as a Mozilla plug-in.

Access the site with the error code as the subdomain name:
http://<<3 character facilty>-<5 digit error number>.ora-code.com/
Example

http://ora-06250.ora-code.com/
TOAD Knowledge Expert Instant Message
This is the most comprehensive explanation method for all Oracle errors. The red area shows all the Oracle error group messages covered. The green area shows the error explanation. The blue area shows the errors in the error group.

HOW TO translate error messages




consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 10:24 AM EDT (about this update About This Update consultium Edited by consultium

2 words added
1 word deleted

view changes
- complete history)
Keyword tags: ERROR MESSAGE HOWTO ORA OERR
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.