Php persistant connections to oracle

jd · 2002-12-11 22:11:06

Hi Just wondering have people used OCINLogon to connect to an oracle database and kept the connection open through various scripts. I'm dubious if it will do what is intended - ie not commit the outstanding transactions until OCICommit is called but de boss thinks it should be done this way...

11-12-2002 11:11PM

#1

jd

Registered Users, Registered Users 2, Paid Member Posts: 5,863 ✭✭✭

Join Date: November 1999

Posts: 5526

Hi
Just wondering have people used OCINLogon to connect to an oracle database and kept the connection open through various scripts. I'm dubious if it will do what is intended - ie not commit the outstanding transactions until OCICommit is called but de boss thinks it should be done this way...

0

Comments

#2 20-12-2002 02:45PM

Tom Dunne

Registered Users, Registered Users 2 Posts: 23,202 ✭✭✭✭

Join Date: May 2001

Posts: 21043

While I have used the OCINLogon and stuff over one script, I haven't used while keeping the connection open over several. However, have you looked at Ora_Commitoff and Ora_Commiton? I imagine these would solve your problem by keeping Oracle from committing transactions until OCICommit is called.

0