Database Administration (MOSC)

MOSC Banner

reading an old version of a package in memory

Code is running in order with ORA-04061: existing state of has been invalidated

The invalid code reference is NOT to an invalid database object, but because the code is reading an old version of the package stored in memory

The fix is to Flush the Shared Pool.


I acknowledge the fact that code changes were done recently, but, this action did NOT result in new invalid objects. That is, invalid objects in the database. That part is pretty clear and obvious.

So, the issue here is a caching issue, and by means of the fix that issue would be located in the Shared Pool.

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