Data Masking Fails If 'Compond Trigger' Exists. (Doc ID 1912849.1)

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

On : 12.1.0.1.0 version, EM Data Masking Pack

When attempting to mask a table which has compund trigger,
the following error occurs.

ERROR
-----------------------
ERROR executing steps
ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword
errorExitOraError!



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
create table (t2)
-create compound trigger for this table (t2)
-create another table (t1) with unique primary on field f1.
-create foreign key dependency from table t2 to f1.
-make datamodel and masking definitions for shuffling values of column f1 on table t1.
-generate script for data masking.
-save script. Check script and see that for-keyword is missing from create trigger definition for compound trigger.

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