USER_ERRORS

2025-11-14 07:33:33  Updated

Note

This view is available starting with V2.2.30.

Purpose

This view displays the error information of the storage objects owned by the current user.

Applicability

This view applies only to OceanBase Database in Oracle mode.

Columns

Field name Type Nullable? Description
NAME VARCHAR2(128) NO The name of the object.
TYPE VARCHAR2(19) NO The type of the object:
  • VIEW
  • PROCEDUCE
  • FUNCTION
  • PACKAGE
  • PACKAGE_BODY
  • TRIGGER
  • TYPE
  • TYPE BODY
  • LIBRARY
  • JAVA SOURCE
  • JAVA CLASS
  • DIMENSION
SEQUENCE NUMBER NO The error number of the errors that occur during the same compilation (not sorted).
LINE NUMBER NO The line number where the error occurs.
POSITION NUMBER NO The column number where the error occurs.
TEXT VARCHAR2(4000) NO The error message.
ATTRIBUTE VARCHAR2(9) NO Indicates whether the error is an error or a warning.
MESSAGE_NUMBER NUMBER NO The error code.

References

Contact Us