Trigger and rollback.. [message #37074] |
Tue, 15 January 2002 22:17  |
Sreenivas Gattu.
Messages: 2 Registered: October 2001
|
Junior Member |
|
|
Hello All,
We have the trigger which will be executed when a record is inserted into a table.This trigger will inform some other applications abt this change.But the problem here is the transaction may be rolled back after inserting a record and when we roll back, the trigger will not be called and the applications will asuume that the record is inserted which is actually not true.
How can a Trigger know when the transaction is rolled back..
Please help me..
Regards,
Sreenivas Gattu
|
|
|
Re: Trigger and rollback.. [message #37084 is a reply to message #37074] |
Wed, 16 January 2002 12:06  |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
it is not possible in trigger because trigger code will be executed during insert not at the time of rollback. store those messages in separate table (from trigger) and schedule job to send those messages to application.
|
|
|