Re: Is there a trigger on session end?
Date: Thu, 28 Feb 2008 21:38:17 -0800 (PST)
Message-ID: <aca3efc9-ecc0-48e8-b3fb-a60c1930af5c@s8g2000prg.googlegroups.com>
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