Posted by Mladen Gogala on 04/10/06 09:41

On Mon, 10 Apr 2006 00:08:38 +0200, Tijs Verwest wrote:

> 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...


I responded to this on comp.databases.oracle.server. Please, crosspost,
don't multipost.

--
http://www.mgogala.com

[Back to original message]