Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> trigger on view
I try to create ea trigger on View
---
CREATE TRIGGER "GECOM"."IN_VW_FATTOMEGA" INSTEAD OF
INSERT
ON "VW_FATTUREPEROMEGA"
FOR EACH ROW
---
and when I compile i got alway an ORA-25005 error
CREATE INSTEAD OF impossible on view only read.
BUt is possible this on View or I must create a Materialized View from the Query Tables.
Tnks Alen, Italy Received on Fri Sep 09 2005 - 08:06:38 CDT