Re: Can we trigger event for abnormal loss of connection to oracle databse?

From: DA Morgan <>
Date: Wed, 08 Oct 2008 08:08:13 -0700
Message-ID: <>

shilpa wrote:
> Hi,
> First I want to identify Lost database connection at database level.
> Based on that I want to perform some updataions in my tables.
> Like one event LOGOFF in case of ORACLE . But don't know how to catch
> this event and perform updations. Please tell me solution for the
> same.
> More specifically when connection lost i want to run stored procedure
> which will update my dayabase entries if any mismatch in tables.
> Thanks
> Shilpa

Use a system event trigger trap the BEFORE LOGOFF event. Alternatively try trapping the AFTER SERVERERROR event.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Oct 08 2008 - 10:08:13 CDT

Original text of this message