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 JANUARY 30, 2019

Applies to:

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

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

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
Purpose
Troubleshooting Steps
 Introduction
 Investigating Invalidations
 ORA-4068 errors when a package contains only constant variables
 How to Deal with Unexpected Invalidations
 Gathering Information for Unexpected Invalidation Issues
References

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