DBA_ERRORS

2023-12-25 08:49:41  Updated

Purpose

The DBA_ERRORS view displays errors on current stored objects in the database.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

  • ALL_ERRORS

  • USER_ERRORS

Columns

Column 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 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.

    Contact Us