ORA-30505: system triggers should not reference a column in a WHEN clause ORACLE 报错 故障修复 远程处理

文档解释

ORA-30505: system triggers should not reference a column in a WHEN clause

Cause: An attempt was made to use a WHEN clause to reference a column with a system trigger, but this type of trigger is not supported because a system trigger does not have a base table.

Action: Change the WHEN clause to an appropriate clause.

>ORA-30505: system triggers should not reference a column in a WHEN clause错误表明在使用触发器时，不应该在WHEN子句中引用表中列。

官方解释

常见案例

一般处理方法及步骤

– 确保触发器不在WHEN子句中引用列

– 在触发器WHEN子句中使用if条件语句而不是列

– 确保在触发器中使用的完全限定的表别名

– 检查触发器的定义，检查是否有不允许的列访问