Accessing TABLE From READ ONLY DATABASE Using DATABASE LINK Within PL/SQL Fails With ORA-06550 ORA-04063 or PLS-00905
(Doc ID 358697.1)
Last updated on AUGUST 09, 2020
Applies to:PL/SQL - Version 126.96.36.199 and later
Information in this document applies to any platform.
***Checked for relevance on 04th Aug 2018***
Accessing TABLE From READ ONLY (STANDBY) DATABASE Using DATABASE LINK Within PL/SQL Fails With ORA-06550 ORA-04063 or PLS-00905
To reproduce in remote read only Database:
In local database:
If local and remote database have version between Oracle9i 9.2.0 to Oracle 11.2 or later it fails with:
If local database have versions between Oracle8 8.0.6 to Oracle8i 8.1.7 it fails with :
If Local Database has a version higher than Oracle9i 9.2.0 and remote Database a version lower than Oracle9i 9.0.1 then it could fails with ORA-00600 
Work OK When Accessing TABLE Using SQL From READ ONLY (STANDBY) DATABASE Using DATABASE LINK
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