DBMS.PIPE

From: Kristiaan Boschman <kristiaan.boschman_at_online.be>
Date: Mon, 8 Nov 1999 21:06:13 +0100
Message-ID: <807a6i$nlt$1@trex.antw.online.be>

I want to send a message to another application at the moment a transaction commits.
Can I use DBMS_PIPE for this ?

I would do the following

In transaction Tx updates are done on table A. I create a trigger on table A, which sends a message to the pipe. Transaction Ty periodically reads the messages from the pipe.

What happens if the update of table A fails, will Ty have received a message ? I hope not.

If Ty would also receive uncommitted changes, then I need another solution.

Kind regards, Lydia Received on Mon Nov 08 1999 - 14:06:13 CST