Avoiding ORA-04068: existing state of packages has been discarded
source: Avoiding ORA-04068: existing state of packages has been discarded | Mark Hoxey (wordpress.com) If you’re trying to run your database as close to 24×7 as possible, with no downtime for updates, then one thing you will need to avoid is the following error: ORA-04068: existing state of packages has been discarded Package state comes about when a package has variables or cursors defined at the package level, as opposed to local variables within procedures and functions. According to the PL/SQL…