How to compile all the invalid database objects in a schema in a single shot

Execute the following PL/SQL Block from the SQL prompt/Database

DECLARE

CURSOR invalid_objects

IS

SELECT object_name,

object_type

FROM user_objects

WHERE object_type IN ('PACKAGE', 'PACKAGE BODY')

AND status = 'INVALID'

AND object_name LIKE 'OZF%'

ORDER BY object_type;

BEGIN

FOR rec IN invalid_objects

LOOP

DBMS_DDL.ALTER_COMPILE (rec.object_type ,'APPS' ,rec.object_name);

dbms_output.put_line (rec.object_name || ' has been compiled.');

END LOOP;

END;