Oracle Error ORA-25035: cannot perform DML on remote object from a crossedition trigger

Oracle Error Message

ORA-25035: cannot perform DML on remote object from a crossedition trigger

Reason for the Error

An attempt was made to do DML from a crossedition trigger that would modify data in a remote database. DML from a crossedition trigger has special rules applied regarding what triggers will fire as part of that DML; these special rules cannot be applied across database links and therefore the DML cannot be allowed.

Solution

Perform the DML in a helper function separate from the crossedition trigger itself; the special rules are not applied when the DML is not issued from within the crossedition trigger itself.