| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Sending message from Oracle to MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| MichaelGoltsman |
 Posted: Wed Jan 30, 2002 3:42 am Post subject: |
 |
|
Novice
Joined: 14 Nov 2001
Posts: 10
|
Hi All,
Does anyone have an experience in sending messages from stored procedure of Oracle to MQ? |
|
| Back to top |
|
 |
| jhalstead |
| Posted: Thu Jan 31, 2002 6:03 am Post subject: |
|
|
Master
Joined: 16 Aug 2001
Posts: 258
Location: London
|
I've Done this type of thing in the following manner.
Called stored procedure via pro*c in a C program which also interacts with the MQSeries queue manager through MQI API. Effectively this is a pull rather than a push though. I don't think you can interact with MQSeries from stored procedures, however let me know if you've found a way!
Thanks
Jamie
[ This Message was edited by: jhalstead on 2002-01-31 06:04 ] |
|
| Back to top |
|
|
| rwa |
| Posted: Mon Feb 11, 2002 11:38 pm Post subject: |
|
|
Voyager
Joined: 22 Jan 2002
Posts: 76
Location: Duesseldorf/Germany
|
Hi Michael,
have a look at SupportPac MAOI.
"This SupportPac provides the Oracle PL/SQL procedure definitions to allow MQSeries API calls to be made from an Oracle PL/SQL program. All API calls are defined with the exception of MQINQ and MQSET"
Rainer |
|
| Back to top |
|
|
| MichaelGoltsman |
| Posted: Mon Feb 11, 2002 11:51 pm Post subject: |
|
|
Novice
Joined: 14 Nov 2001
Posts: 10
|
Hi Rainer,
I've checked it. It works but is not supported by IBM. My company doesn't like lack of support. We want a full-functional commercial tool. Have yuo heard about one?
Regards,
Mike |
|
| Back to top |
|
|
| rwa |
| Posted: Tue Feb 12, 2002 11:58 pm Post subject: |
|
|
Voyager
Joined: 22 Jan 2002
Posts: 76
Location: Duesseldorf/Germany
|
Hi Mike,
I am not an oracle developer, so I can't look into the doc library from oracle. But oracle has it's own message broker which can be connected to MQSeries. If you have access to the doc library, you can search there for an answer.
Regards,
Rainer |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
