Is there a trigger on session end?

From: dean <deanbrown3d_at_yahoo.com>
Date: Thu, 28 Feb 2008 12:20:55 -0800 (PST)
Message-ID: <ca383859-b155-495d-a3f3-ae044185904f@p25g2000hsf.googlegroups.com>


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