Home » SQL & PL/SQL » SQL & PL/SQL » Trigger and rollback..
Trigger and rollback.. [message #37074] Tue, 15 January 2002 22:17 Go to next message
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 Go to previous message
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.
Previous Topic: Active table-update monitoring (using pl/sql?)
Next Topic: how to pass parameters dynamically
Goto Forum:
  


Current Time: Tue Jul 07 05:33:14 CDT 2020