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) NOT NULL	Object owner.
NAME	VARCHAR2 (30) NOT NULL	Object name.
TYPE	VARCHAR2 (12) 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) NOT NULL	Indicates whether the error is an error (ERROR) or a warning (WARNING).
MESSAGE_NUMBER	TT_INTEGER	Numeric error number (without any prefix).