Re: Tricky trigger

A copy of this was sent to Laurent Cheyssial <laurent.cheyssial_at_commonway.com> (if that email address didn't require changing) On Fri, 19 Feb 1999 19:48:26 +0100, you wrote:

>Hi there,
>
>does anybody knows if it is possible, on a given database, to trigger a
>PL/SQL procedure when an user close his connection (either
>intentionnally or not)?
>
>Thanks,
>
>LCH./.
[Quoted] Not until Oracle8i (8.1)

there you can have triggers on:

database startup
database shutdown
logon
logout
servererror
CREATES of objects
ALTERS of objects
DROPS of objects

in addition to insert/update/delete on a table or view.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation