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 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 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!