Google it ....

Wednesday, September 30, 2020

PLS-908: The stored format is not supported by this release ORA-06541: PL/SQL: compilation error ORA-06553: PLS-1: ORA-06540

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 release
On 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!

No comments:

Post a Comment