Oracle trigger-Mutation Table trigger cannot access this table

1CREATEORREPLACETRIGGER  trgregisterpregroup2   UPDATE 3    on tblregisterusers 4    for Each ROW 5     ... 6 END Trgregisterpregroup;

A trigger is created on table Tblregisterusers, which is a row-level trigger, which can be: old and; New data

However, you can no longer select operations on the mutation table, or you will report an exception

Reason:

When you create a row-level trigger on a table, the following two restrictions apply:

1. Can not read or modify any trigger statement of the variation table;
2. You cannot read or modify a column of the primary key,unique or FOREIGN key keyword for a constraint table of a contact publication, but you can modify the other columns

Workaround:

But it's going to be a problem.

Solution, add commit at the end;

Oracle trigger-Mutation Table trigger cannot access this table