-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- Author : Sameer S Choudhari -- Description : Report the errors on the stored objects (i.e. PL/SQL,Views,Triggers,etc.) in the database. -- Call Syntax : @dba_errors_all.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 ORDER BY TYPE, OWNER, NAME;