Data Masking Fails If 'Compond Trigger' Exists.
Last updated on NOVEMBER 10, 2016
Applies to:Enterprise Manager for Oracle Database - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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