Re: Is there a trigger on session end?
Date: Fri, 29 Feb 2008 00:08:34 -0800
> 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.orgReceived on Fri Feb 29 2008 - 02:08:34 CST