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

VIEW: SYS.USER_ERRORS

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

Current errors on stored objects owned by the user

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 NAME
,      TYPE
,      SEQUENCE
,      LINE
,      POSITION
,      TEXT
,      ATTRIBUTE
,      MESSAGE_NUMBER
FROM SYS.USER_ERRORS;

Dependencies

[top of page]

SYS.USER_ERRORS references the following:

SchemaSYS
TableERROR$
View_CURRENT_EDITION_OBJ
SYS.USER_ERRORS is referenced by following:

SchemaPUBLIC
SynonymUSER_ERRORS
SchemaSYS
Package BodyDBMS_PSP - show dependent code
Package BodyGET_ERROR$ - show dependent code