A little background:
Today, we have several tables in our DB2 LUW environment where after update, insert, and delete triggers are defined. When these triggers are fired, an MQ Message is formatted and then sent to an IBM MQ message queue via an MQSEND DB2 function. These messages are then picked up by TibCo messaging and made available to the application. The unit of work for an IDU statement consists of a successful update of data and assurance that the message was successfully published to the MQ queue, i.e. a 2-phase commit.

We now have a need to do something similar in Oracle. The databases that we need to do this are currently at 11.2.0.4 running on AIX. If possible, we would like some guidance in regards to what options are available in Oracle…. Particularly at a no cost solution. It’s not necessary to go thru MQ… we just need to get the JMS message to a message queue that the application can consume. Any suggestions to getting us going down the best path is greatly appreciated.