ID: 31222
Updated by: [EMAIL PROTECTED]
Reported By: amonw at hotmail dot com
-Status: Open
+Status: Assigned
Bug Type: OCI8 related
Operating System: redhat linux 7.2
PHP Version: 4.3.10
-Assigned To:
+Assigned To: tony2001
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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] [EMAIL PROTECTED]
Thanks, it would be very nice.
------------------------------------------------------------------------
[2004-12-22 09:19:32] amonw at hotmail dot com
I tried compiling oci8 statically and it produced the same result.
I'm building a test system. After I finish it, I'll send you a telnet
account to test, if you're willing to.
------------------------------------------------------------------------
[2004-12-21 15:05:16] [EMAIL PROTECTED]
Yes, I tried to run exactly your code, with one modification: I changed
login & password.
4.2.2 is too old to talk about, try PHP 5.0.3 instead, if you can.
Also, it would be nice if you try to compile OCI8 module statically and
to run the same code with it.
------------------------------------------------------------------------
[2004-12-21 14:56:44] amonw at hotmail dot com
Thanks for your trying and reply.
I tried php-cli and it print the same result plus a new line with some
blanks and no records was deleted either.
And I tried php 4.2.2 on the other machine connected to oracle
8.1.7,php 4.3.10 connected to oracle 9.2.0.1.0,php 4.2.2 connected to
oracle 9.2.0.1.0. They all produced the same result. Except that when I
used php-cli 4.2.2, it also printed "Segmentation fault" at the end.
Are you sure you used exactly the same code as I quoted?
As I mentioned, even some minor changes which seem not relevant may
affect the result.
Thank you again for your quick response.
------------------------------------------------------------------------
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
