| How to upadate a table when oracle session terminates abruptly [message #38502] |
Tue, 23 April 2002 03:05  |
Deepak Khemani
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
|
I want to know if there is a way we can update a table if a oracle session terminates abruptly... we face a problem that there is a table which gets updated when we logout from our system ... but this will not happen if the oracle forms get close abruptly .. so we want to know that if such kind of thing can be handled in any way
|
|
|
|
| Re: How to upadate a table when oracle session terminates abruptly [message #38523 is a reply to message #38502] |
Wed, 24 April 2002 11:58  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
If there is any specific servererror that is encountered soon as the session terminates ..u can do like
CREATE replace TRIGGER tr1 AFTER SERVERERROR ON DATABASE
BEGIN
IF (IS_SERVERERROR (Server errorno)) THEN
--Update ur table
END IF;
END;
/
I think oracle also gives us new type trigger for the event BEFORE LOGOUT
but I am not sure whether that wud fire if the session terminates
check that option too
HTH
oraboy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
