Hi Chucks,
select the status of the objects from dba_objects....by
select object_name,object_type from dba_objects where status like 'INVALID';
if you have invalid objects you will get a list otherwise you get no row selected...
if you have invalid objects...
try this script....as sys


set heading off
set pagesize 0
set linesize 79
set verify off
set echo off

spool comp_all.tmp

select
decode( OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;' )
from
dba_objects A,
sys.order_object_by_dependency B
where
A.OBJECT_ID = B.OBJECT_ID(+) and
STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE',
'TRIGGER', 'VIEW' )
order by
DLEVEL DESC,
OBJECT_TYPE,
OBJECT_NAME;

spool off

thanks.
Thanigaivasan.