3 Replies Latest reply: Dec 2, 2011 4:05 AM by 778027 RSS

    Oracle ESB DB Adapter PLSQL calling commit gives ORA-02089 in XA Datasrc

    656258
      Hi,

      On the RAC environment where SOA and database are two node RAC, we have deployed an ESB which calls a PLSQL procedure on Oracle EBS 12.0.4. Now there is commit statement inside the PLSQL procedure. On calling the commit, it gives following error:
      Error Message ORA-02089: COMMIT is not allowed in a subordinate session

      Please note that the db adapter datasource is set up as XA datasource.

      Is there a way in ESB to commit the database session like we have it in BPEL with idempotent property or putting the DB call in a scope or calling orabpel api?

      Please let me know if there is better way to solve the issue.

      Thanks,
      Bhavnesh.