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.