If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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

Options

11-12-2002 11:11pm

#1

jd

Registered Users Posts: 5,695 ✭✭✭

Join Date: November 1999

Posts: 5360

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

Options
#2 20-12-2002 2:45pm
Tom Dunne

Registered Users Posts: 23,212 ✭✭✭✭

Join Date: May 2001

Posts: 21052

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