Skip to Main Content

DevOps, CI/CD and Automation

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!

Transaction handling problem using oci_execute with OCI_DEFAULT

458920Apr 11 2007 — edited Apr 18 2007
I have a PHP Class which handles all Oracle inserts, deletes and updates. I use oci_execute with OCI_DEFAULT option which will not autocommit the transaction. I use this class whereever I need database operations. My problem is - If my caller program calls oci_execute (which is in my class) more than once, it automatically commits the previous transaction without executing oci_commit. It works fine If I call the oci_execute with OCI_DEFAULT from the same script. But the problem occurs when I call oci_execute with OCI_DEFAULT from a calling script and leaves without commit. In such cases subsequent call automatically commits the previous transaction.

Hope somebody helps me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2007
Added on Apr 11 2007
9 comments
5,071 views