| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle resultset passing Message Broker |
« View previous topic :: View next topic » |
| Author |
Message
|
| szab |
 Posted: Thu Apr 16, 2009 7:18 am Post subject: Oracle resultset passing Message Broker |
 |
|
Novice
Joined: 01 May 2008
Posts: 14
|
Hi!
I haven' t found anything similar to this problem in the topics, so the problem is..
the Request part:
I have a flow that calls an Oracle(10g) stored procedure, which inserts some values of the incoming XML file into the DB...
the Reply part:
Is it possible to send to the Broker a result set, that is generated from an other ORACLE procedure, which is called from an update trigger?
So, can the ORACLE procedure call a message flow somehow?
I've been thinking if the next theory of mine could be work:
Oracle calls a JAVA stored procedure( java file is in a messagflow project ) -> the JAVA file contains some MQ functions so, that it can create a simple message, which can be put to a queue -> and a message flow which starts with an MQget node ....
Any other ideas how to pass a resultset to a Broker?
szab |
|
| Back to top |
|
 |
| Vitor |
| Posted: Thu Apr 16, 2009 7:25 am Post subject: Re: Oracle resultset passing Message Broker |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| szab wrote: |
| So, can the ORACLE procedure call a message flow somehow? |
You don't call a message flow. You put data in one end.
If your flow calls a stored procedure, why isn't the result set returned to the flow as a parameter?
| szab wrote: |
| which can be put to a queue -> and a message flow which starts with an MQget node .... |
You of course mean an MQInput node.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| bhumulas |
| Posted: Thu Apr 16, 2009 9:09 am Post subject: |
|
|
Apprentice
Joined: 17 Feb 2006
Posts: 41
|
| SET Environment.Variables.Result[] = PASSTHRU ('CALL SP(in1, in2)'); |
|
| Back to top |
|
|
| szab |
| Posted: Thu Apr 16, 2009 10:18 am Post subject: |
|
|
Novice
Joined: 01 May 2008
Posts: 14
|
Actually, after inserting the data into the db, another application updates/writes some of these rows( don't know what time) , that's why i'm using a trigger for that action, and i want the updated rows to be sent back to the broker...
Thus i can't have it all in one message flow( i think... )
I hope it's clear enough now...  |
|
| 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
|
|
|
|
