Invalid Package body KUPW$WORKER
595762Oct 8 2007 — edited Oct 8 20071)After installing patches and after installation found that
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------ ---------------------- ------------------- ------------
SYS KUPW$WORKER PACKAGE INVALID
SYS KUPW$WORKER PACKAGE BODY INVALID
According to Note:394569.1 -- ran the
-@$ORACLE_HOME/rdbms/admin/catdpb.sql
It didn't help.
2) Also drop the x package as follow:
sqlplus "/as sysdba"
SQL> @?/rdbms/admin/catnodp.sql
2) Then recreate it as follow:
sqlplus "/as sysdba"
SQL> @?/rdbms/admin/catdph.sql
SQL> @?/rdbms/admin/catdpb.sql
and did not help.
3) Reported errors when trying to compile the pkg manually:
SQL> alter package SYS.KUPW$WORKER compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY SYS.KUPW$WORKER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
10682/7 PL/SQL: Statement ignored
10682/32 PLS-00302: component 'MT_FLAGS_TABLE_EXISTED' must be declared
14347/15 PL/SQL: Statement ignored
14347/50 PLS-00302: component 'MT_FLAGS_TABLE_EXISTED' must be declared
SQL> select object_name, object_type from dba_objects where status='INVALID' and owner='SYS';
OBJECT_NAME OBJECT_TYPE
---------------------------------------- -------------------
KUPW$WORKER PACKAGE BODY
KUPP$PROC PACKAGE BODY
Thanks in advance.