MY_ERRORS

MY_ERRORS displays the latest compilation error information about user-owned storage objects. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in both the PG_CATALOG and SYS schemas.

**Table 1** MY_ERRORS columns
Name	Type	Description
name	character varying(128)	Object name.
type	character varying(12)	Object type. PROCEDURE FUNCTION PACKAGE PACKAGE BODY
sequence	numeric	Serial number.
line	numeric	Row where an error occurs.
position	numeric	Position in the row where an error occurs.
text	character varying(4000)	Error text.
attribute	character varying(9)	Attribute tag: ERROR.
message_number	numeric	Not supported. Its value is NULL.