Re: creating a trigger on v$session.module

"moklet" <ratshek_at_telkom.co.za> wrote in message news:a8701c69.0406030424.51743c10_at_posting.google.com...
> i've been trying to create an insert/update trigger on v_$session but
> with no success. following is my code:
>
> 1 create or replace trigger trg_module
> 2 instead of insert or update on t_$session
> 3 begin
> 4 delete from t_modes;
> 5* end;
> SQL> /
>
> Trigger created.
>
> (t_$session is a view of sys.v_$session).
>
> as you can see the trigger compiles ok but the code ('delete ...') is
> never run when there is a change in v$session. one explanations i got
> was that you cannot put this trigger on a view of a fixed table/view.
>
> the reason i'm doing this is to monitor changes in v$session.module
> and then execute some code. if there is another way of achieving this
> i would appreciate the advice.
>
> regards,
\
How about a log on trigger? You shouldn't put triggers on a sys object. Jim Received on Thu Jun 03 2004 - 16:18:11 CEST