OCI_DEFAULT and OCI_COMMIT_ON_SUCCESS

[Tijs Verwest]

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_S UCCESS (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_S UCCESS
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...

[Mladen Gogala]

Re: OCI_DEFAULT and OCI_COMMIT_ON_S UCCESS

On Mon, 10 Apr 2006 00:08:38 +0200, Tijs Verwest wrote:
[color=blue]
> 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_S UCCESS (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_S UCCESS
> 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...[/color]


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

--

http://www.mgogala.com

[Tijs Verwest]

Re: OCI_DEFAULT and OCI_COMMIT_ON_S UCCESS

How do you cross post ?


"Mladen Gogala" <gogala@sbcglob al.net> a écrit dans le message de news:
pan.2006.04.10. 06.41.27.541919 @sbcglobal.net...[color=blue]
> On Mon, 10 Apr 2006 00:08:38 +0200, Tijs Verwest wrote:
>[color=green]
>> 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_S UCCESS (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_S UCCESS
>> 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...[/color]
>
>
> I responded to this on comp.databases. oracle.server. Please, crosspost,
> don't multipost.
>
> --
> http://www.mgogala.com
>[/color]

[Tim Van Wassenhove]

Re: OCI_DEFAULT and OCI_COMMIT_ON_S UCCESS

On 2006-04-10, Tijs Verwest <stephane.volle t@bluewin.ch> wrote:[color=blue]
> How do you cross post ?[/color]

The first link i got after searching the web for "cross-post":

http://www.cs.tut.fi/~jkorpela/usenet/xpost.html

The rest of http://www.cs.tut.fi/~jkorpela/usenet/ seems like good
reading material too.

--
Met vriendelijke groeten,
Tim Van Wassenhove <http://timvw.madoka.be >