Re: trigger on view

"Alen Cappelletti" <cocker_at_libero.it> wrote in news:1126271198.703886.51970_at_g47g2000cwa.googlegroups.com:

> 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
>
>

25005, 00000, "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.