DECLARE
   CURSOR pack_cur IS
      SELECT object_type,owner,object_name
      FROM   all_objects
      WHERE  object_type LIKE 'PACKAGE%'
      AND    owner LIKE UPPER('&schema')
      ORDER BY object_name,object_type;
BEGIN
   FOR pack IN pack_cur LOOP
      DBMS_DDL.alter_compile (pack.object_type,
                              pack.owner,
                              pack.object_name);
   END LOOP;
END;
/