rem *************************************************************

rem * Name : SHOWERR.SQL

rem *

rem * Date: July 15 2001

rem * Purpose: Show errors from all invalid objects

rem *

rem * Downloaded from www.oradev.com

rem *************************************************************



set feedback off

set heading off

set pages 0

set linesize 128



prompt These errors are found in invalid objects



select ' show err '|| object_type || ' '|| object_name

from   user_objects

where  status = 'INVALID';



spool error.sql

/

spool off



set feedback on

set heading on

set pages 100

@error.sql