Re: Is there a trigger on session end?
Date: Thu, 28 Feb 2008 21:38:17 -0800 (PST)
crash scenario only happened under unexpected situation....so i don't think it is logical to AUTOMATICALLY EXECUTE something.....unless u can wrap that session with a exception handler to handler the many different exceptions that can occurred. since the scenario are too many or possibly infinite....i don't think u want to do AUTOMATICALLY... dean $B<LF;!'(B
> 10g / Win
> I have a trigger that calls a procedure when a user logs off session:
> create or replace trigger LoggedOff
> before logoff on database
> call procLoggedOff
> But this trigger is not called if my session ends unexpectedly - a
> crash or if the app is killed by some means (simple crash, compiler
> reset, CTRL-ALT_DEL, etc).
> Is there a way to get Oracle to call a procedure when it determines
> that a session has been killed or otherwise has died?
> Thanks in advance for any advice.
Received on Thu Feb 28 2008 - 23:38:17 CST