Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Triggers on Views fire for table?

Triggers on Views fire for table?

From: Luch <optimaljedi_at_nospam.net>
Date: Tue, 04 Dec 2001 03:45:13 GMT
Message-ID: <dFXO7.26383$WC1.2733755@newsread2.prod.itd.earthlink.net>


I have table t_table with view v_view on it (create view v_view as select * from t_table;)

What I want is to place a trigger on the view v_view, so that when an insert or upate is done into t_table the trigger fires. Is this possible? The reason I ask is because I only have access to the v_view, and I don't even know (or have rights) to what table it's coming from.

When I try placing a trigger on v_view, it only fires if an insert/update is done "through" the view itself, but not the table. Is this the only way triggers on views work?

--
Luch
replace nospam with usa for e-mail.
Received on Mon Dec 03 2001 - 21:45:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US