PLS-907 cannot load library block

Question

The following is my Oracle version of Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64-bit production

I tried to modify the table to add a column, but since it took a long time, I canceled it.

After some time, I began to see errors in all packages and views that referenced the device. Error message

PLS-907: Unable to load library block (table name)

The error in this error does not provide much information. In one place, I saw that the team below will help, but it seems to me a very risky team

change system flush shared_pool

Can someone help me with a reason and a solution to this?

Thanks Jivan

Answer 1

this is because the database links are deleted and recreated for connections, so just recompiling the package will allow it, and sometimes it will automatically recompile it.