Updated on 2024-06-03 GMT+08:00

DB_ERRORS

DB_ERRORS displays the latest compilation error information about storage objects accessible to users. By default, it is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 DB_ERRORS columns

Name

Type

Description

owner

character varying(128)

Object owner.

name

character varying(128)

Object name.

type

character varying(12)

Object type.
  • PROCEDURE
  • FUNCTION
  • PACKAGE
  • PACKAGE BODY

sequence

numeric

Serial number.

line

numeric

Row where an error occurs.

position

numeric

Not supported. Its value is NULL.

text

character varying(4000)

Error text.

attribute

character varying(9)

Attribute tag: ERROR.

message_number

numeric

Not supported. Its value is NULL.