Patch 6061184 Throws Rdcpb.Sql Pls-00323 Getrdciappstatusdisplay (Doc ID 811241.1)

Last updated on MAY 15, 2009

Applies to:

Oracle Clinical - Version: 4.5.3
This problem can occur on any platform.

Symptoms

While trying apply patch 6061184 the log file indicates that while attempting to run script file rdcpb.sql
The following error message is thrown:

ERROR MESSAGES:

Running rdcpb.sql

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY RDC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
45/11 PLS-00323: subprogram or cursor 'GETRDCIAPPSTATUSDISPLAY' is
declared in a package specification and must be defined in the
package body

55/11 PLS-00323: subprogram or cursor 'GETRDCIVERSTATUSDISPLAY' is
declared in a package specification and must be defined in the
package body

60/11 PLS-00323: subprogram or cursor 'GETAPPOPDISPLAY' is declared in
a package specification and must be defined in the package body


LINE/COL ERROR
-------- -----------------------------------------------------------------
63/11 PLS-00323: subprogram or cursor 'GETVEROPDISPLAY' is declared in
a package specification and must be defined in the package body


NAVIGATION / REPLICATION PATH / CONFIGURATION CONTROL:
Base Release/Patchset: 4.5.3

Follow steps to apply patch 6061184


OCCURRENCE PATTERNS: this is the third time applying this patch. Both previous attempts completed
successfully without any error messages. As far as you can tell the exact same steps were
followed as when applying the patches the previous two times. Although there must be something
different to cause the package spec (RDC) and package body to be out of synch.

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