Posted by Tijs Verwest on 04/10/06 01:08

I found this on http://www.orafaq.com/faqphp.htm :

When using the OCI Extension Module, PHP will commit whenever ociexecute()
returns successfully. One can control this behaviour by specifying
OCI_COMMIT_ON_SUCCESS (the default) or OCI_DEFAULT as the second parameter
to the ociexecute() function call. OCI_DEFAULT can be used to prevent
statements from being auto-committed. The OCICommit() and OCIRollback()
functions can then be used to control the transaction.

But I don't see any difference between OCI_DEFAULT and OCI_COMMIT_ON_SUCCESS
both commit my insertions in the database. Can someone tell me what's the
difference between the two?

I use OCI_DEFAULT all the time and I never have to commit anything...

[Back to original message]