I faced the below error PLS-00907: cannot load library unit FUNC_EMP_DETAILS (referenced by ) The objects are valid state only. After some time, I started seeing errors in all packages and views that referenced the unit. Error message is PLS-00907: cannot load library unit (table name)
Googling on this error does not give much information. In one place, I saw that below command will help but it seems to me as very risky command alter system flush shared_pool
Can anyone help me with the reason and solution to this? Thanks, Abdul |