My Oracle Support Banner

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

Last updated on FEBRUARY 25, 2019

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

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
References

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