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 18.104.22.168 and later
Information in this document applies to any platform.
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