Purpose
The USER_ERRORS view displays errors related to the currently stored objects owned by the user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_ERRORSDBA_ERRORS
Columns
| Column | 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. |
