Purpose
USER_ERRORS displays errors on current stored objects owned by the user.
Related views
ALL_ERRORSDBA_ERRORS
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| NAME | VARCHAR2(128) | NO | The name of the object. |
| TYPE | VARCHAR2(19) | NO | The type of the object. Valid values: |
| 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 line where an error occurred. |
| POSITION | NUMBER | NO | The position 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. |