| Author |
Message
|
| marshall |
 Posted: Fri Dec 16, 2005 7:42 am Post subject: MQ from PL/SQL ? |
 |
|
Newbie
Joined: 16 Dec 2005
Posts: 4
|
Is there any way to utilize MQ within a PL/SQL procedure? I have MQ setup for another system and would like to utilize it if possible. Thanks.
Jeff |
|
| Back to top |
|
 |
| EddieA |
| Posted: Fri Dec 16, 2005 9:24 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Support Pac MA0I. 
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| marshall |
| Posted: Fri Dec 16, 2005 9:30 am Post subject: |
|
|
Newbie
Joined: 16 Dec 2005
Posts: 4
|
| I just found that a few minutes ago. Do you know if just having the MQ client installed will be sufficient or do we have to have a full install? thanks. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Dec 16, 2005 9:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I wonder if the support pack documentation mentions if it works with a client or not?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| marshall |
| Posted: Fri Dec 16, 2005 10:55 am Post subject: |
|
|
Newbie
Joined: 16 Dec 2005
Posts: 4
|
| I didnt see anything in the readme. Not much of anything else document wise......... |
|
| Back to top |
|
|
| EddieA |
| Posted: Fri Dec 16, 2005 11:25 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
Looking through the samples, I can only see places to put a QM and Queue, so I would guess that it won't work with a Client.
But, all the source code is provided, so "hack away".
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| marshall |
| Posted: Fri Dec 16, 2005 11:34 am Post subject: |
|
|
Newbie
Joined: 16 Dec 2005
Posts: 4
|
| Maybe I'm just an idiot today but does the MQ install have to be on the server that the database I'll be using pl/sql is on? The reason I ask is that I have a full install on another server. I didnt see anything in the samples about setting the MQ hostname which is what I do when using Java to indicate the server that the queue manager is on. Thanks. |
|
| Back to top |
|
|
| EddieA |
| Posted: Fri Dec 16, 2005 12:05 pm Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| marshall wrote: |
| does the MQ install have to be on the server that the database I'll be using pl/sql is on? |
| EddieA wrote: |
it won't work with a Client
all the source code is provided, so "hack away" |
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Dec 16, 2005 12:28 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you looked at the Oracle Messenging Gateway?
This allows you to use AQ only in Oracle and magically it gets transferred to MQ!.
Enjoy  |
|
| Back to top |
|
|
|
|
