My Oracle Support Banner

RXC.OCL_DCIF PACKAGE BODY INVALID - NUM_PAGES: invalid identifier (Doc ID 453685.1)

Last updated on DECEMBER 25, 2019

Applies to:

Oracle Clinical - Version 4.5.1 to 4.5.1 [Release 4.5.1]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When creating a new Data Collection Module (DCM), after using the following navigation:

    Definition > DCMs > DCMs > Save,

you receive the following error:

    123400: ORA-04068: existing state of packages 0 has been discarded
    ORA-04063: package body "RXC.OCL_DCIF" has errors

Next upon attempting to recompile the package body "RXC.OCL_DCIF" you receive the following error:

Line # = 96 Column # = 2 Error Text = PL/SQL: SQL Statement ignored
Line # = 122 Column # = 2 Error Text = PL/SQL: ORA-00904: "NUM_PAGES": invalid identifier

Changes

A recent update in the package RXC.OCL_DCIF.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.