My Oracle Support Banner

Troubleshooting PL/SQL Program Unit Invalidation Related Errors (e.g. ORA-4068, ORA-4065, ORA-6508, PLS-907) (Doc ID 2298084.1)

Last updated on DECEMBER 02, 2023

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.


This note provides advice on handling and investigating errors that arise at runtime due to recompilation of PL/SQL objects.  These errors may be as a result of automatic or manual recompilation having taken place or because automatic recompilation has failed.  The most common errors seen in this area are:

Typically a PL/SQL block will fail with several of these errors on the stack, usually starting with ORA-4068.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 Investigating Invalidations
 ORA-4068 errors when a package contains only constant variables
 How to Deal with Unexpected Invalidations
 Gathering Information for Unexpected Invalidation Issues

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.