From: kennedy-downwithspammersfamily@attbi.net   
      
   "moklet"  wrote in message   
   news: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,   
   \   
   How about a log on trigger?  You shouldn't put triggers on a sys object.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)