Dbms_metadata Package Body Invalid After CPU Installation (Doc ID 334645.1)

Last updated on OCTOBER 21, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.4 and later   [Release: 10.1 and later ]
IBM AIX on POWER Systems (64-bit)

Symptoms

Apply of CPUJUL2005 patch renders package DBMS_METADATA invalid after having run catcpu.sql:

Warning: Package Body altered with compilation errors.

Verified the issue by the error ourput, which displays:

Select object_name,object_type from dba_objects where status = 'INVALID'
results in : Package body for DBMS_METADATA is invalid.
Manual compilation results in:
SQL> alter package dbms_metadata compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY DBMS_METADATA:
LINE/COL ERROR
-------- -----------------------------------------------------------------
668/13 PLS-00323: subprogram or cursor 'GET_DPSTRM_MD' is declared in a
package specification and must be defined in the package body

The issue may reappear during rollback of the patch and running catcpu_rollback.sql as well.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms