Transaction handling problem using oci_execute with OCI_DEFAULT
458920Apr 11 2007 — edited Apr 18 2007I 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.