SYS.ALL_ERRORS

The ALL_ERRORS describes the current errors on the stored objects accessible to the current user.

Related views

• SYS.DBA_ERRORS describes the current errors on all stored objects in the database. It has the same columns as ALL_ERRORS.

• SYS.USER_ERRORS describes the current errors on the stored objects that are owned by the current user. This view does not display the OWNER column.

Columns

Column name	Type	Description
OWNER	VARCHAR2(30) INLINE	Object owner
NAME	VARCHAR2(30) INLINE	Object name
TYPE	VARCHAR2(12) INLINE NOT NULL	Object type (such as PROCEDURE, FUNCTION, PACKAGE)
SEQUENCE	TT_INTEGER NOT NULL	Sequence number (for ordering purposes)
LINE	TT_INTEGER NOT NULL	Line number at which the error occurred
POSITION	TT_INTEGER NOT NULL	Position in line at which the error occurred
TEXT	VARCHAR2(4000) NOT INLINE NOT NULL	Text of the error
ATTRIBUTE	VARCHAR2(9) INLINE NOT NULL	Error classification: ERROR or WARNING
MESSAGE_NUMBER	TT_INTEGER	Numeric error number (without any prefix)