Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Adapter Polling with muliple ORDER BY Columns

Marcel MertinJun 18 2013 — edited Jul 3 2013

Hi,

we are using Oracle SOA Suite 11g with AIA. Currently we are using in one scenario the DB Adapter to poll one DB table with a ORDER BY statement on a single column (DATECREATED). Now we would like to extend the ORDER BY with priority. In DB Adapter Wizard it is not possible to edit the pure SQL. Is it possible to edit the query somewhere else? Is the DB Adapter Polling restricted to have only one ORDER BY column?

Bye
Marcel

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2013

Added on Jun 18 2013

#11g, #adapter, #database, #integration-adapters, #integration-general, #soa, #soa-process-management

7 comments

4,212 views