Re: Is there a table containing ORACLE error codes?
Date: Sun, 14 Mar 1993 21:00:43 GMT
Message-ID: <1993Mar14.210043.7974_at_netcom.com>
In article <C3uGv9.EAw_at_vistachrome.com> andy_at_vistachrome.com writes:
>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?
>You can also use 'sqlerrm' to get the SQL Error message while
>in Pro*C programs.
A Pro* programming tip: use the sqlglm() (SQLLIB get long message) function to get the text of error messages. sqlca.sqlerrm.sqlerrmc will only give you the first 70 bytes of error message, with sqlglm() you can get the full text. It's documented in all the 1.4 and 1.5 Pro* language supplements.
sqlglm() may require an extra server call, however.
With the OCI, use OERHMS, not OERMSG, to get more than 70 bytes of error text.
--Tim (tssmith_at_netcom.com) Received on Sun Mar 14 1993 - 22:00:43 CET