Skip to Main Content
Forums

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!

ora-02089-COMMIT is not allowed in a subordinate session - V'urgent pls

Sen2008Oct 29 2010 — edited Feb 27 2020
All,
BPEL version: 11.1.1

I have to invoke a pl/sql procedure which inserts a data to a table. After insert, I used commit. When BPEL try to invoke this procedure, I got ora-02089-COMMIT is not allowed in a subordinate session+. I know without commit in pl/sql, BPEL does the commit. But for a requirement, I've to explicitly use COMMIT inside the procedure. How do I go about in this case?

Please advise.

Thanks,
Sen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2010
Added on Oct 29 2010
#business-process-management-suite, #soa-process-management
3 comments
6,712 views