Re: Is there a table containing ORACLE error codes?

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?

Under Unix you can access `oerr ora 1401` and receive:

01401, 00000, "inserted value too large for column" // *Cause:
// *Action:

You can also use 'sqlerrm' to get the SQL Error message while in Pro*C programs.

It certainly would not be impossible to load the data that 'oerr' (a shell script) searches into an Oracle table.

>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.
 

>Note: I am NOT using SQL*Forms (and will not convert my client/server
>applications to SQL*Forms).
 

>--
>Bill Meahan |EFHD Information Systems Staff
>Plant Floor Systems Specialist |Ford Motor Company
>wwm_at_ef5003.efhd.ford.com | +1 313 487 6122
>..!fmsrl7!pmsmam!wwm |I'm not paid to speak for Ford!

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy_at_vistachrome.com, andy_at_genie.geis.com.
"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72