Re: Is there a trigger on session end?

From: DA Morgan <>
Date: Fri, 29 Feb 2008 00:08:34 -0800
Message-ID: <>

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 (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Feb 29 2008 - 02:08:34 CST

Original text of this message