Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Package body KUPW$WORKER

595762Oct 8 2007 — edited Oct 8 2007
1)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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2007
Added on Oct 8 2007
2 comments
1,066 views