Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ERRORS

Object Details
Object Name: DBA_ERRORS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Current errors on all stored objects in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes
NAME VARCHAR2 (128) Yes Name of the object
TYPE VARCHAR2 (12)
Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE BODY", "TRIGGER", "JAVA SOURCE" or "JAVA CLASS"
SEQUENCE NUMBER
Yes Sequence number used for ordering purposes
LINE NUMBER
Yes Line number at which this error occurs
POSITION NUMBER
Yes Position in the line at which this error occurs
TEXT VARCHAR2 (4000) Yes Text of the error
ATTRIBUTE VARCHAR2 (9)
MESSAGE_NUMBER NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      NAME
,      TYPE
,      SEQUENCE
,      LINE
,      POSITION
,      TEXT
,      ATTRIBUTE
,      MESSAGE_NUMBER
FROM SYS.DBA_ERRORS;

Dependencies

[top of page]

SYS.DBA_ERRORS references the following:

SchemaSYS
TableERROR$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.DBA_ERRORS is referenced by following:

SchemaPUBLIC
SynonymDBA_ERRORS
SchemaSYS
Package BodyDBMS_REPCAT_SQL_UTL - show dependent code