| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-01 |
|
|
View PDF |
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:
|
|
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) |
