Data Masking Fails If 'Compound Trigger' Exists.
(Doc ID 1912849.1)
Last updated on APRIL 03, 2021
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 compound 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!
In this Document