SELECT DISTINCT u.object_name,
decode(u.object_type,'PACKAGE BODY','PACKAGE',u.object_type) object_type,
u.created
FROM user_objects u
WHERE u.status = 'INVALID'
AND u.object_type IN ('PROCEDURE','FUNCTION','PACKAGE BODY','PACKAGE')
ORDER BY u.created
1]]
[]'s
: Wink: