| Author |
Message
|
| marko |
 Posted: Mon Oct 21, 2002 8:25 am Post subject: Can an Oracle DB trigger put a message on an MQ queue? |
 |
|
Apprentice
Joined: 28 Feb 2002
Posts: 27
|
I would like to have an Oracle trigger put a message on a queue to kick off a flow. Is there any free Oracle package to do this?
We are using Oracle 8.1.7 on HPUX.
Thanks.
. |
|
| Back to top |
|
 |
| marko |
| Posted: Tue Oct 22, 2002 5:40 am Post subject: |
|
|
Apprentice
Joined: 28 Feb 2002
Posts: 27
|
|
| Back to top |
|
|
| tchagan |
| Posted: Tue Oct 22, 2002 6:27 am Post subject: |
|
|
Apprentice
Joined: 10 Feb 2002
Posts: 31
|
Hi,
we currently use oracle AQ and the Oracle Message Broker to interface between Oracle and MQ, there is a little bit of setting up to do with the OMB and some scripts to write but this is the preferred solution to interfacing between Oracle and MQ. You basically use the trigger to put a message onto an AQ queue, the OMB polls this queue and when a message is received the OMB will transfer the message to MQ.
Terry |
|
| Back to top |
|
|
| marko |
| Posted: Tue Oct 22, 2002 11:35 am Post subject: |
|
|
Apprentice
Joined: 28 Feb 2002
Posts: 27
|
Thanks Terry.
Is OMB free? Is there a separate process to maintain with OMB?
I also wanted to avoid polling. I'm currently polling Oracle, and when there are records in a particular state I'm adding them into an input queue. I would prefer to use an Oracle trigger to put messages directly into the input queue to avoid the polling latency. |
|
| Back to top |
|
|
| tchagan |
| Posted: Wed Oct 23, 2002 1:10 am Post subject: |
|
|
Apprentice
Joined: 10 Feb 2002
Posts: 31
|
Hi,
I believe that OMB comes with Oracle8i and onwards.
In the scenario I describe the polling is necessary and is the standard way for Oracle to add messages to an mq input queue. However in Oracle8i you can call java classes so potentially you could use the mq java API called from a trigger to put messages on a queue though I haven't tried this.
hope this helps
Terry |
|
| Back to top |
|
|
| marko |
| Posted: Wed Oct 23, 2002 9:00 am Post subject: |
|
|
Apprentice
Joined: 28 Feb 2002
Posts: 27
|
| Thanks for the tips. I will also check into using Java. |
|
| Back to top |
|
|
|
|
