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 MAY 31, 2024

Applies to:

Purpose

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

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