Re: Is there a trigger on session end?

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
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Is there a trigger on session end?
    ... I have a trigger that calls a procedure when a user logs off session: ... Is there a way to get Oracle to call a procedure when it determines ...
    (comp.databases.oracle.server)
  • Re: Oracle9: Can I create a variable for each session?
    ... that this variable must be created for each session. ... > inserts a row with session-id and user-id and trigger has to look into ... Oracle 10g Certified Professional ... "If you don't eat your meat, you cannot have any pudding. ...
    (comp.databases.oracle.misc)
  • Re: print problem with multiuser
    ... It's possible the printers weren't removed correctly and when the new user logs in with the same session id that the orignial user had, they also picked up the printers. ... Microsoft MVP - Terminal Server ...
    (microsoft.public.windows.terminal_services)
  • Re: Problem in service with User Fast-Switching
    ... That session ID is which triggered the session change event. ... A user logs off then logs on previously unopened account ... A user logs off then logs previously opened account ...
    (microsoft.public.win32.programmer.kernel)
  • Re: ASP.NET Forms Authentication - How to Know if User Has Previously Been Authenticated
    ... the user logs on to my site and checks "Remember my ... ID" (persistent cookie). ... logged in" because their FormsAuthentication ticket was set to ... Request.IsAuthenticated = false when they open the new session. ...
    (microsoft.public.dotnet.framework.aspnet)