Set heading off;
set feedback off;
set echo off;
Set lines 999;
Spool run_invalid.sql
select 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;'
from DBA_OBJECTS
where STATUS = 'INVALID' AND OWNER='ATLMS2' and OBJECT_TYPE='PROCEDURE';
spool off;
set heading on;
set feedback on;
set echo on;
@run_invalid.sql
