---- SQL Script for Validating Invalid Objects
set head off set pagesize 0 set linesize 132 set feedback off set termout off set echo off spool 2.sql select 'ALTER '||object_type||' '||object_name||' compile;' STRING from user_objects where status='INVALID' and object_type in ('VIEW', 'PACKAGE', 'TRIGGER', 'PROCEDURE', 'FUNCTION') order by object_type desc / spool off set feedback on set termout on set echo on
---SQL Script for Validating Invalid Objects
set head off set pagesize 0 set linesize 132 set feedback off set termout off set echo off spool 4.sql select 'ALTER PACKAGE '||object_name||' compile body;' STRING from user_objects where status='INVALID' and object_type='PACKAGE BODY' / spool off set feedback on set termout on set echo on