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

Last updated on NOVEMBER 19, 2008

Applies to:

Oracle Clinical - Version: 4.5.1 to 4.5.1
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

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