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

ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Feedback +Status: Open Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 Assigned To: tony2001 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2004-12-23 13:26:48] amonw at hotmail dot com Just in case, did you receive my email with a test account? I sent it about 8 hours ago. ------------------------------------------------------------------------ [2004-12-22 10:01:10] tony2001@php.net Thanks, it would be very nice. ------------------------------------------------------------------------ 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