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

Last updated on SEPTEMBER 28, 2015

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 "USU1"."PAQUETE1" 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 "USU1"."PAQUETE1" COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY "USU1"."PAQUETE1":

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/4 PL/SQL: Statement ignored
15/13 PLS-00905: object USU2.PAQUETE2 is invalid


In the reported case the second package USU2.PAQUETE2 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms