creating a trigger on v$session.module

From: moklet <ratshek_at_telkom.co.za>
Date: 3 Jun 2004 05:24:29 -0700
Message-ID: <a8701c69.0406030424.51743c10@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, Received on Thu Jun 03 2004 - 07:24:29 CDT