My Oracle Support Banner

Compilation Fails When Referencing Record Type on Remote Database : ORA-4054 Database Link <Name> Does Not Exist (Doc ID 1324699.1)

Last updated on FEBRUARY 03, 2022

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.Symptoms

Consider the Scenario:

A record type is declared in Schema C
In Schema A a package uses this record type via a dblink (remote DB ) to Schema C.
A package in Schema B is compiled with a reference to the package in Schema A.

Compiling the package in schema B fails with:

ORA-04054 database link <name> does not exist

An example is given below:


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

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