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

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:

Cause

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