Anybody have ideas how to get around or a good way to deal with this. I was
given only select access to a certain view, I don't even know what table
it's coming from. I want to process each record as it comes into the view
(just like an insert trigger on a table).
--
Luch
replace nospam with usa for e-mail.
"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
news:9uigng09bl_at_drn.newsguy.com...
> In article <dFXO7.26383$WC1.2733755_at_newsread2.prod.itd.earthlink.net>,
"Luch"
> says...
> >
> >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?
> >
>
> yes, triggers only fire on the object upon which they are defined.
>
> A trigger on a view fires if and only if you insert/update/delete the
view.
> Triggers on tables only fire when you modify the table.
>
>
> >--
> >Luch
> >replace nospam with usa for e-mail.
> >
> >
> >
> >
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
>
Received on Tue Dec 04 2001 - 19:59:53 CST
