My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : version, EM Data Masking Pack

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

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

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.