Home » SQL & PL/SQL » SQL & PL/SQL » OnConnect/OnDisconnect events?
OnConnect/OnDisconnect events? [message #36343] Mon, 19 November 2001 01:03 Go to next message
Nicola Farina
Messages: 63
Registered: October 2001
Member
Hi all,

Is it possible to fire the execution of a stored procedure each time a user starts/close a (new) connection (somewhat like a "session trigger") ?

TIA
Bye
Nicola

----------------------------------------------------------------------
Re: OnConnect/OnDisconnect events? [message #36350 is a reply to message #36343] Mon, 19 November 2001 10:45 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
in 8.1.5 you can. Each new connection will be a new session(logon).
create or replace trigger scott_logon
after logon on SCOTT.schema
begin
my_proc;
end;
/

----------------------------------------------------------------------
Previous Topic: Hiding tablenames and using synonyms ?
Next Topic: Any easy way to run PL/SQL?
Goto Forum:
  


Current Time: Thu Mar 28 06:14:10 CDT 2024