Re: Is there a table containing ORACLE error codes?

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?
>
>I'd like to provide something meaningful to my users.

Use the 'oerr' program.

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.

>
>--
>Bill Meahan |EFHD Information Systems Staff
>Plant Floor Systems Specialist |Ford Motor Company

Mirek Piaseczny
University of British Columbia Received on Fri Mar 12 1993 - 19:53:25 CET