On one of our database development team member getting below error when trying to use remote database package procedure into local view, which have execute privilege on remote object:
ORA-04052: eror occured when looking up remote object test.test_pack@testdb ORA-06541: PL/SQL: compilation error - compilation aborted ORA-06553: PLS-1: ORA-06540: PL/SQL: compilation error ORA-06553: PLS-908: The stored format of test.test_pack@testdb is not supported by this releaseOn metaLink there is doc PLS-908 Error When Objects Are Accessed Across a DBLink (Doc ID 824951.1) and it's bug, but in our case we have other version than doc says and also development team member said that this view was working some times ago, ooh this was hint for me and I tried to flush shared_pool with command:
SQL> ALTER SYSTEM FLUSH SHARED_POOL;
on database where view exist and bingo! it's working now and everybody are happy!
