DBMS_PIPE.SEND_MESSAGE() help [message #41226] |
Wed, 11 December 2002 06:00 |
Ramki
Messages: 26 Registered: September 2002
|
Junior Member |
|
|
Hi all,
I am using DBMS_PIPE.SEND_MESSAGE() in a before insert/update/delete trigger
but my send message is happening even when my main table insert/update/delete fails due to some constraints
I want this message to be send only when my main table insert/update/delete is succeed.
any solution for this.
thanks
|
|
|
Re: DBMS_PIPE.SEND_MESSAGE() help [message #41230 is a reply to message #41226] |
Wed, 11 December 2002 10:57 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
From the trigger, insert the dbms_pipe call in the job queue (dbms_job) as a run-once job. It will only execute if the transaction is successful.
This approach works very well for anything that should fire in a trigger (like an email), but only if the transaction completes without exception.
|
|
|