DB Adapter Returning Results In Different Order than running Store Procedure directly from Database
(Doc ID 2810882.1)
Last updated on MAY 16, 2023
Applies to:
Oracle Service Bus - Version 12.2.1.3.0 and laterOracle SOA Suite - Version 12.1.3.0.0 and later
Information in this document applies to any platform.
Symptoms
On : 12.2.1.3.0 version, OSB Transports
ACTUAL BEHAVIOR
---------------
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
EXPECTED BEHAVIOR
-----------------------
to have the same results order
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |