REP-0008 with Ref Cursor Based Report when Connected to Different DB (Doc ID 272936.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Reports Developer - Version 9.0.2.0 to 10.1.2.3 [Release 9i to 10gr2]
Information in this document applies to any platform.


Symptoms

Running the reports ( .rep) based on ref cursor gives the following errors when
connecting to different but identical database instance:

REP-0008: Run time error in the PL/SQL development environment (DE).
PDE-PSD001 Could not resolve reference to < unknown program unit > while
loading < unknown > < unknown >
REP-0008: Unexpected memory error while initializing preferences.

Changes

The reports are run against a different database instance.

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