Re: Is there a table containing ORACLE error co

In article 1nq7vnINNnp6_at_ef2007.efhd.ford.com, wwm_at_ef5003.efhd.ford.com (Bill Meahan) writes:
>
>Is there a table in ORACLE (or some other mechanism) by which a user
>program could get the short description of an ORACLE error given the
>error code number?
>
>That is, if I get an error of 1401 (or 01401) is there some way I can
>obtain the short description:
> Inserted value to large for column
>without resorting to the ORACLE Error Messages and Codes Manual?

There's the 'oerr' facility - I don't know if it is common across all platform - which effectively does a search of various .msg files eg for SUN they're in $ORACLE_HOME/<product>/mesg/*.msg based on product/facility and language.

For example :

$ oerr
Usage: oerr facility error

Facility is identified by the letter prefix in the error number. 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.

$ oerr ora 1401
01401, 00000, "inserted value too large for column" // *Cause:
// *Action:

---
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=++=+=+=+=+=+=+
| Davina Gray			Sun Microsystems Scotland BV |
| davina.gray_at_uk.sun.com	Linlithgow		     |
| Tel: +44-506-672284		West Lothian		     |
| Fax: +44-506-670011		Scotland  EH49 7LR	     |
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=++=+=+=+=+=+=+