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!

SOA 11G Database adapter issue with commit.

658542Mar 9 2010 — edited Mar 9 2010

Hi,

We are using a XA data source to connect to a database. When we are executing a PL/SQL API using a database adapter, we are getting the following error message.

ORA-02089: COMMIT is not allowed in a subordinate session at process_currency_exc_rate_list

For a different API we are getting the following error message.

ORA-02074: cannot SET NLS in a distributed transaction

We are having commit statement in the PL/SQL API.

The same problem is not observed when a data source is used which is not XA enabled.

Did any one encounter such a problem. Why is this behavior newly observed in 11G SOA

Edited by: Srinivasa Raju I on Mar 9, 2010 3:28 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2010

Added on Mar 9 2010

#11g, #adapter, #database, #issue, #soa, #soa-process-management, #soa-suite-discusssions, #with

2 comments

1,730 views