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>
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