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

From: DA Morgan <>
Date: Sat, 11 Oct 2008 11:17:36 -0700
Message-ID: <>

shilpa wrote:
> On Oct 9, 4:03 am, Palooka <> wrote:

>> ddf wrote:
>>> What sort of 'updataions' (which isn't a word)?
>> The sort one gets as a result of outsourcing.
>> Palooka

> Hi All,
> I want to trap LOGOFF event. Please tell me how to trap event in
> oracle.
> After trapping this event I want to perform some steps.

Then by all means do so. <g>

> Please tell me a way to execute a stored procedure and perform some
> steps when a LOGOFF event occur.

Read the docs at Look up BEFORE LOGOFF and SYSTEM EVENT TRIGGER. If you then have questions ask specific questions about specific versions and post links to what you read.

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

Original text of this message