This discussion is archived
0 Replies Latest reply: Nov 14, 2012 8:05 AM by 974249 RSS

Need some help with sending a SQL query results to OEG / JMS

974249 Newbie
Currently Being Moderated
I’m working on a model that will send the results from an Oracle SQL query to remote Web Service:

Oracle DB 11gR2 -> Oracle Enterprise Gateway -> ActiveMQ -> Windows .Net Client Service -> Remote Web Service

All current versions.

So far I have the path from the Oracle Gateway to the Web Service working.

What I’m missing is the SQL query to OEG I'm not sure how to route SQL query to send the results to ActiveMQ.

I used the following document to setup the model.
http://www.oracle.com/technetwork/middleware/id-mgmt/documentation/activemq-oeg-integration-guide-428892.pdf

I’m looking to see if anyone has an example of the SQL query to OEG.

Thanks in advance for any help you may provide.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points