ORA-25004: WHEN clause is not allowed in INSTEAD OF triggers
Cause: WHEN clause is specified in an INSTEAD OF trigger.
Action: Remove the WHEN clause when creating an INSTEAD OF trigger.
ORA-25004,错误是指你尝试把WHEN子句放在INSTEAD OF触发器中,但是只有在BEFORE或AFTER子句中才可以使用 WHEN 子句。
ORA-25004: “WHEN” Clause is not allowed in Instead Of Triggers
you tried to place the WHEN clause in an Instead Of trigger, but the WHEN clause can only be used in BEFORE or AFTER clauses.
使用INSTEAD OF触发器来侦听DML视图时,尝试使用WHEN语句。
1、不要将WHEN子句放在INSTEAD OF触发器,而应该将其放在BEFORE/AFTER触发器中。
2、如果要使用WHEN子句,使用INSTEAD OF触发器则不可能,因此您应根据需求来选择触发器类型。