Re: Can we trigger event for abnormal loss of connection to oracle databse?
Date: Wed, 08 Oct 2008 08:08:13 -0700
> 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
> More specifically when connection lost i want to run stored procedure
> which will update my dayabase entries if any mismatch in tables.
Use a system event trigger
http://www.psoug.org/reference/system_trigger.html trap the BEFORE LOGOFF event. Alternatively try trapping the AFTER SERVERERROR event.
-- 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 Wed Oct 08 2008 - 10:08:13 CDT