Re: Can we trigger event for abnormal loss of connection to oracle databse?
From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 11 Oct 2008 11:17:36 -0700
Message-ID: <1223749052.950105@bubbleator.drizzle.com>
>
> 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.
Date: Sat, 11 Oct 2008 11:17:36 -0700
Message-ID: <1223749052.950105@bubbleator.drizzle.com>
shilpa wrote:
> On Oct 9, 4:03 am, Palooka <nob..._at_nowhere.com> 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 http://tahiti.oracle.com. 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Oct 11 2008 - 13:17:36 CDT