ALL_ERRORS

ALL_ERRORS describes current errors on all stored objects (views, procedures, functions, packages, and package bodies) accessible to the current user.

Related Views

DBA_ERRORS describes all current errors on all views, procedures, functions, packages, and package bodies in the database.
USER_ERRORS describes all current errors on all views, procedures, functions, packages, and package bodies owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object
`NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object
`TYPE`	`VARCHAR2(12)`		Type of the object: `VIEW` `PROCEDURE` `FUNCTION` `PACKAGE` `PACKAGE BODY` `TRIGGER` `TYPE` `TYPE BODY` `LIBRARY` `JAVA SOURCE` `JAVA CLASS` `DIMENSION`
`SEQUENCE`	`NUMBER`	`NOT NULL`	Sequence number (for ordering purposes)
`LINE`	`NUMBER`	`NOT NULL`	Line number at which the error occurred
`POSITION`	`NUMBER`	`NOT NULL`	Position in the line at which the error occurred
`TEXT`	`VARCHAR2(4000)`	`NOT NULL`	Text of the error
`ATTRIBUTE`	`VARCHAR2(9)`		Indicates whether the selected row is an error (`ERROR`) or a warning (`WARNING`)
`MESSAGE_NUMBER`	`NUMBER`		Numerical error number (without any prefix)