My Oracle Support Banner

Datamasking Scripts Reports ORA-24344: Success With Compilation Error (Doc ID 1260245.1)

Last updated on AUGUST 17, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

Running a Data Masking script in Grid Control 11G  may fail with the error ORA-24344: "success with compilation error" when a package or another object needs to be recompiled and the dependencies can only be resolved using object privileges.

Changes

You are trying to mask a table that has references to objects in other schemas or is being referenced by objects in other schemas such as views or stored pl/sql objects.

A typical example of the sort of errors you may get are:


ALTER PACKAGE "<schema1>"."<obj1>" COMPILE BODY
ERROR executing steps
ORA-24344: success with compilation error
errorExitOraError!


When you investigate the issue and try the failing statement manually:


SQL> ALTER PACKAGE "<SCHEMA1>"."<obj1>" COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY "<SCHEMA1>"."<obj1>":

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/4 PL/SQL: Statement ignored
15/13 PLS-00905: object <schema2>.<obj2> is invalid


In the reported case the second package <schema2>.<obj2> depended on a view that was also invalid because the owner of the view had no privileges on the base tables (with grant option).

Cause

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
Symptoms
Changes
Cause
Solution
References


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