Transaction handling problem using oci_execute with OCI_DEFAULT

[vinod_pv]

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.

[gluck]

Is auto commit on?

[Feenix566]

I suspect that your class and your calling script are both using the same Oracle connection. Try having your class open up its own connection to Oracle, and keep it private. That way only the class will be able to commit its own transactions.