-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Report the errors on specified object (i.e. PL/SQL,Views,Triggers,function etc).
-- Call Syntax  : @dba_errors_specified_object.sql
-- Last Modified: 20/06/2017
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN TYPE FORMAT a20
COLUMN owner FORMAT a30
COLUMN name FORMAT a30
COLUMN text FORMAT a60
SELECT *
FROM dba_errors
WHERE owner=upper('&owner')
  AND name=upper('&object_name')
ORDER BY
  type,
  owner,
  name;