Check the invalid objects and generate script for compiling
SELECT owner,
'alter ' || REPLACE( object_type, ' BODY',
'') || ' ' || owner || '.' || object_name || ' compile ' || DECODE
(object_type, 'PACKAGE BODY', 'BODY', '' ) || ';' "Compile-Syntax"
FROM all_objects
WHERE status = 'INVALID'
GROUP BY owner, object_type, object_name
ORDER BY owner, object_type, object_name;
Tags:
Oracle