ORA Tips
ORA-25004 WHEN clause is not allowed in INSTEAD OF triggers

Tips to resolve Oracle® Database errors

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.

Related Error Messages to ORA-25004 WHEN clause is not allowed in INSTEAD OF triggers

ORA-24950 unregister failed, registeration not found

ORA-25000 invalid use of bind variable in trigger WHEN clause

ORA-25001 cannot create this trigger type on views

ORA-25002 cannot create INSTEAD OF triggers on tables

ORA-25003 cannot change NEW values for this column type in trigger

ORA-25005 cannot CREATE INSTEAD OF trigger on a read-only view

ORA-25006 cannot specify this column in UPDATE OF clause

ORA-25007 functions or methods not allowed in WHEN clause

ORA-25008 no implicit conversion to LOB datatype in instead-of trigger

ORA-25009 Nested table clause allowed only for INSTEAD OF triggers


Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates.