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.
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.