Recompile all Oracle objects (requires access to dba_objects). If running as a user schema, you can use user_objects instead.

oracle_recompile_objects.sql

set heading off; 
set feedback off; 
set echo off; 
Set lines 999; 

spool run_invalid.sql 

select  'ALTER ' || OBJECT_TYPE || ' ' ||  OWNER || '.' || OBJECT_NAME || ' COMPILE;' 
from dba_objects 
where status = 'INVALID' 
and object_type in ('PACKAGE','FUNCTION','PROCEDURE');

spool off;

set heading on; 
set feedback on; 
set echo on; 

@run_invalid.sql