Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

DIA-25035

cannot perform DML on remote object from a crossedition trigger

Cause

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.


Action

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.