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

Tips to resolve Oracle® Database errors

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

Cause
Attempt to create an INSTEAD OF trigger on a view created with read-only option. The view cannot be updated using INSTEAD OF triggers.

Action
Do not create the trigger.

Related Error Messages to ORA-25005 cannot CREATE INSTEAD OF trigger on a read-only view

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-25004 WHEN clause is not allowed in INSTEAD OF triggers

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

ORA-25010 Invalid nested table column name in nested table clause


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