We are running Oracle 19 database.

Sometimes when you have an urgent problem to solve we make changes directly on the production database. I know it’s not recommended at all but let’s imagine a case when we have no other choice.

We compile all the objects. No object is invalid, but yet we still get this error : existing state of package body “PACKAGE.NAME” has been invalidated persists

Sometimes the database may run smoothly until a process gets into a specific package then the entire database is unusable.

According to our analysis, checking for invalid objects is definitely not a way to anticipate this error.

Assuming a certain state of database objects, does anyone know how we can detect that this error may happen ? or be sure the change we have made to the database wont cause this error and everything is fine.

Thanks.