The Package body of UTL_RECOMP object is invalid. When I tried to compile it it returns errors
and the body persists to be invalid for that reason. How to resolve it?
SQL> select object_name,object_type ,status from dba_objects where object_name='UTL_RECOMP';
OBJECT_NAME OBJECT_TYPE STATUS
----------- ------------- ---------
UTL_RECOMP PACKAGE VALID
UTL_RECOMP PACKAGE BODY INVALID
SQL> ALTER PACKAGE UTL_RECOMP COMPILE BODY;
Warning: Package Body altered with compilation errors.
SQL> SHOW ERROR
Errors for PACKAGE BODY UTL_RECOMP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
605/10 PL/SQL: SQL Statement ignored
605/31 PL/SQL: ORA-00942: table or view does not exist
610/10 PL/SQL: Statement ignored
610/34 PLS-00364: loop index variable 'OLD_JOBS' use is invalid
618/10 PL/SQL: Statement ignored
618/34 PLS-00364: loop index variable 'OLD_JOBS' use is invalid
626/10 PL/SQL: Statement ignored
626/34 PLS-00364: loop index variable 'OLD_JOBS' use is invalid