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

ORA-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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:46

ORA-25035：无法对来自交叉触发器的远程对象执行DML,
.原因：尝试从将修改远程数据库中的数据的交叉触发器执行DML。来自交叉触发器的DML具有关于什么触发器将作为DML的一部分而应用的特殊规则; 这些特殊规则不能跨数据库链接应用，因此不能允许DML。,
.操作：在与交叉触发器本身分开的辅助函数中执行DML; 当DML不是从交叉触发器本身内发出时，不应用特殊规则。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题