Is there a trigger on session end?

From: dean <>
Date: Thu, 28 Feb 2008 12:20:55 -0800 (PST)
Message-ID: <>

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 - 14:20:55 CST

Original text of this message