#31222 [Asn->Fbk]: ocicommit not working

ID: 31222 Updated by: tony2001@php.net Reported By: amonw at hotmail dot com -Status: Assigned +Status: Feedback Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. Previous Comments: ------------------------------------------------------------------------ [2005-04-05 01:25:39] sniper@php.net Back to Antony ------------------------------------------------------------------------ [2005-04-04 09:27:40] amonw at hotmail dot com I tried the http://snaps.php.net/php4-STABLE-latest.tar.gz,which extracted to be php4-STABLE-200504040230,but the code produced the same result. ------------------------------------------------------------------------ [2005-03-30 23:06:56] tony2001@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-STABLE-latest.zip ------------------------------------------------------------------------ [2004-12-24 03:08:50] amonw at hotmail dot com Thank you for your help. But can you explain why the 4 methods I listed in the first comment can change the result? And why can't I add "ocilogoff($c)" before the second ocilogon to change the result? ------------------------------------------------------------------------ [2004-12-23 18:16:12] tony2001@php.net You need to use ocinlogon() in this case, because you have 2 similar connections (which are indeed ONE connection) messing around. One of these connections still needs commit and gets rollback'ed at the end of the script execution and one of them doesn't. So, this is quite expected. There is another problem: this issue doesn't exist in PHP5 ocilogon()/oci_connect() because behaves similar to ocinlogon()/oci_new_connect() and returns exclusive connection descriptor. This is not the intended behaviour and I'll investigate who and why changed it. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/31222 -- Edit this bug report at http://bugs.php.net/?id=31222&edit=1