VIEW: SYS.DBA_ERRORS

Source

View Text - Preformatted

select u.name, o.name,
decode(o.type#, 4, 'VIEW', 7, 'PROCEDURE', 8, 'FUNCTION', 9, 'PACKAGE',
               11, 'PACKAGE BODY', 12, 'TRIGGER', 13, 'TYPE', 14, 'TYPE BODY',
               22, 'LIBRARY', 28, 'JAVA SOURCE', 29, 'JAVA CLASS',
               43, 'DIMENSION', 87, 'ASSEMBLY', 'UNDEFINED'),
  e.sequence#, e.line, e.position#, e.text,
  decode(e.property, 0,'ERROR', 1, 'WARNING', 'UNDEFINED'), e.error#
from sys."_CURRENT_EDITION_OBJ" o, sys.error$ e, sys.user$ u
where o.obj# = e.obj#
  and o.owner# = u.user#
  and o.type# in (4, 7, 8, 9, 11, 12, 13, 14, 22, 28, 29, 43, 87)

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, DECODE(O.TYPE#
, 4
, 'VIEW'
, 7
, 'PROCEDURE'
, 8
, 'FUNCTION'
, 9
, 'PACKAGE'
, 11
, 'PACKAGE BODY'
, 12
, 'TRIGGER'
, 13
, 'TYPE'
, 14
, 'TYPE BODY'
, 22
, 'LIBRARY'
, 28
, 'JAVA SOURCE'
, 29
, 'JAVA CLASS'
, 43
, 'DIMENSION'
, 87
, 'ASSEMBLY'
, 'UNDEFINED')
, E.SEQUENCE#
, E.LINE
, E.POSITION#
, E.TEXT
, DECODE(E.PROPERTY
, 0
, 'ERROR'
, 1
, 'WARNING'
, 'UNDEFINED')
, E.ERROR# FROM SYS."_CURRENT_EDITION_OBJ" O
, SYS.ERROR$ E
, SYS.USER$ U WHERE O.OBJ# = E.OBJ#
AND O.OWNER# = U.USER#
AND O.TYPE# IN (4
, 7
, 8
, 9
, 11
, 12
, 13
, 14
, 22
, 28
, 29
, 43
, 87)