| OnConnect/OnDisconnect events? [message #36343] |
Mon, 19 November 2001 01:03  |
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  |
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;
/
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
