PL/SQL (MOSC)

MOSC Banner

Accessing object using dblink Within PL/SQL Fails (lower to higher version)

edited Mar 19, 2023 4:17PM in PL/SQL (MOSC) 2 commentsAnswered

Hi all,

We've some issues with dblink from 11g database (primary) to 19c database (physical standby read only)

  1. When accessing table from physical standby read only (19c) on primary 11g using dblink within PL/SQL Fails with [Error] ORA-04063 table has errors
  2. When accessing function from physical standby read only (19c) on primary 11g using dblink withing PL/SQL Fails with [Error] ORA-06575 Package or function is in an invalid state

There is no problem while we are using the same version databases

Please advice

Thanks,

Iqbal

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center