Updated on 2024-05-07 GMT+08:00

MY_ERRORS

MY_ERRORS displays the latest compilation error information about user-owned storage objects. This view can be accessed by all users. Only the information about the current user can be viewed. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_ERRORS columns

Name

Type

Description

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

Position in the row where an error occurs.

text

character varying(4000)

Error text.

attribute

character varying(9)

Attribute tag: ERROR.

message_number

numeric

Not supported. Its value is NULL.