My Oracle Support Banner

Wrong Dependency of Package on Trigger causing PLS-00801: INTERNAL ERROR [PGM.C:PGMRCM 4] from INTERNAL TRIGGER COMPILATION (Doc ID 3006399.1)

Last updated on FEBRUARY 28, 2024

Applies to:

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


PL/SQL package wrongly depends on a trigger defined on a view, which has a dependency on that pkg

Patch 35037877 addresses this issue and included with 19.20 DB RU.
But with 19.20 one can observe that the Package is still internally referring to Trigger and the Trigger is getting recompiled with error PLS-00801.

We also observe ORA-06544 incident in the alert log during the Package creation.

Applies to both Edition and Non-Editioned views. Not observed over 19.18 with one off Patch of 35037877.


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

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