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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 10:11pm

#1

jd

Registered Users, Registered Users 2 Posts: 5,741 ✭✭✭

Join Date: November 1999

Posts: 5405

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 1:45pm

Tom Dunne

Registered Users, Registered Users 2 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