DB Adapter Returning Results In Different Order than running Store Procedure directly from Database
(Doc ID 2810882.1)
Last updated on SEPTEMBER 30, 2021
Applies to:Oracle Service Bus - Version 18.104.22.168.0 and later
Oracle SOA Suite - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On : 126.96.36.199.0 version, OSB Transports
OSB DB Adapter returning results in different order
We got a case where the return order of a DB Adapter calling a Store Procedure returns the results in a different order than when we call the SP directly from the Database.
when calling the store procedure from DB the order on which the records are returned is different if the store procedure is executed form the DBAdapter
to have the same results order
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document