Re: Is there a trigger on session end?

dean wrote:
> 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.

You can create a SYSTEM EVENT trigger to fire on AFTER SERVERERROR.

Should work for what you want.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org