Description
DBA_ERRORS displays errors on current stored objects in the database.
Related views
ALL_ERRORSUSER_ERRORS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| NAME | VARCHAR2(128) | NO | The name of the object. |
| TYPE | VARCHAR2(19) | NO | The type of the object. Valid values: * VIEW * PROCEDURE * FUNCTION * PACKAGE * PACKAGE_BODY * TRIGGER * TYPE * TYPE BODY * LIBRARY * JAVA SOURCE * JAVA CLASS * DIMENSION |
| SEQUENCE | NUMBER | NO | The sequence number of an error for ordering purposes when multiple errors occurred in one compilation. |
| LINE | NUMBER | NO | The number of the row where an error occurred. |
| POSITION | NUMBER | NO | The number of the column where an error occurred. |
| TEXT | VARCHAR2(4000) | NO | The error text. |
| ATTRIBUTE | VARCHAR2(9) | NO | Indicates whether it is an error or a warning. |
| MESSAGE_NUMBER | NUMBER | NO | The error code. |