Re: trigger on view

Alen Cappelletti wrote:
> Thanks but...
> I'm italian excuse me for my not perfect english.
>
> How I can do this?
> I got a View "VW1", this build-up from a table called "TBLA".
>
> "TBLA" can have 1 o more row for 1 Row into "VW1".
>
> I got a TRIGGER which insert into a second table "TBLB" when there is a
> new row on "VW1". But I can't start the trigger on a view. This is the
> problem.
>
> I hope U understand me.
>
> Thanks Alen.

Post the DDL for the trigger.

And, BTW, what is your Oracle version.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)