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

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