#31222 [Bgs-Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Bogus +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I've read your reply and thank you for trying. But I already mentioned this in the bug description: The oddest thing is I can avoid this by doing any one of the following: 1. don't use the user defined function query, and used it's content to replace the function calls ... (please refer to the first comment I wrote) I know ocicommit does work fine if I code it in other ways,including the 4 methods I mentioned in the bug description. I just don't understand why it doesn't work in my case. Can you explain it? Thank you again. Previous Comments: [2005-06-02 15:17:47] [EMAIL PROTECTED] Tested and replied to you. ocicommit() works fine as I've already told you before. Even if there is an issue, it has nothing to do with ocicommit() and oci8. [2005-05-25 06:36:18] amonw at hotmail dot com I've built a test system and sent the information about it to [EMAIL PROTECTED] You can ssh2 to it and reproduce the problem. Thank you. [2005-05-23 10:13:25] [EMAIL PROTECTED] I can't fix something that I can't reproduce. ocicommit() works just PERFECTLY for me and for others, and the version of PHP doesn't really matter here. [2005-05-23 04:42:23] amonw at hotmail dot com I tried php5 yesterday and the problem doesn't exists. So can you fix it in php4? Thanks. [2005-05-18 00:14:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip We really need to know if this is fixed in HEAD, so please try the snapshot. Nobody is telling you should put it on PRODUCTION machine. You do have some test/dev machines?! 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=31222edit=1
#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: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I've built a test system and sent the information about it to [EMAIL PROTECTED] You can ssh2 to it and reproduce the problem. Thank you. Previous Comments: [2005-05-23 10:13:25] [EMAIL PROTECTED] I can't fix something that I can't reproduce. ocicommit() works just PERFECTLY for me and for others, and the version of PHP doesn't really matter here. [2005-05-23 04:42:23] amonw at hotmail dot com I tried php5 yesterday and the problem doesn't exists. So can you fix it in php4? Thanks. [2005-05-18 00:14:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip We really need to know if this is fixed in HEAD, so please try the snapshot. Nobody is telling you should put it on PRODUCTION machine. You do have some test/dev machines?! [2005-05-17 07:09:52] amonw at hotmail dot com I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. 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=31222edit=1
#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: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I tried php5 yesterday and the problem doesn't exists. So can you fix it in php4? Thanks. Previous Comments: [2005-05-18 00:14:03] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip We really need to know if this is fixed in HEAD, so please try the snapshot. Nobody is telling you should put it on PRODUCTION machine. You do have some test/dev machines?! [2005-05-17 07:09:52] amonw at hotmail dot com I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. [2005-04-29 05:15:01] amonw at hotmail dot com Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip 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=31222edit=1
#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: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I've tried the newest version of php4 but it can't solve my problem. Please refer to my last 2 comments. Previous Comments: [2005-05-12 12:37:33] [EMAIL PROTECTED] I'm not suggesting you to upgrade, I just want you to try newer version. [2005-04-29 05:15:01] amonw at hotmail dot com Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip [2005-04-26 04:20:18] amonw at hotmail dot com I don't know why, but I upgrate my php again this morning to php4-stable-200504260035, and the problem remains unchanged. I have make the code as simple as possible, and as I mentioned in the first comment, even some minor changes which seem not relevant may affect the result, and I don't know why. I deeply appreciate your patiense and please read my first post again. I can live with it if you are tired of this because it takes so long. Thank you. [2005-04-05 17:55:52] [EMAIL PROTECTED] Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. 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=31222edit=1
#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: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: Thank you for your suggestion. But I'm not ready to upgrade my system to php5 because I don't have much time to modify the old codes to fit in php5 yet. Previous Comments: [2005-04-28 12:56:06] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-STABLE-latest.tar.gz For Windows: http://snaps.php.net/win32/php5.0-win32-latest.zip [2005-04-26 04:20:18] amonw at hotmail dot com I don't know why, but I upgrate my php again this morning to php4-stable-200504260035, and the problem remains unchanged. I have make the code as simple as possible, and as I mentioned in the first comment, even some minor changes which seem not relevant may affect the result, and I don't know why. I deeply appreciate your patiense and please read my first post again. I can live with it if you are tired of this because it takes so long. Thank you. [2005-04-05 17:55:52] [EMAIL PROTECTED] Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. [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] [EMAIL PROTECTED] 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 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=31222edit=1
#31222 [NoF-Opn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: No Feedback +Status: Open Bug Type: OCI8 related Operating System: * PHP Version: 4CVS-2005-04-04 Assigned To: tony2001 New Comment: I don't know why, but I upgrate my php again this morning to php4-stable-200504260035, and the problem remains unchanged. I have make the code as simple as possible, and as I mentioned in the first comment, even some minor changes which seem not relevant may affect the result, and I don't know why. I deeply appreciate your patiense and please read my first post again. I can live with it if you are tired of this because it takes so long. Thank you. Previous Comments: [2005-04-13 01:00:03] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to Open. [2005-04-05 17:55:52] [EMAIL PROTECTED] Works just perfectly for all of oci8 users except you. Try to simplify the code and to look for the problem there. [2005-04-05 01:25:39] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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 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=31222edit=1
#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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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=31222edit=1
#31548 [Bgs-Csd]: 1+-.1 produce 1
ID: 31548 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com -Status: Bogus +Status: Closed Bug Type: Scripting Engine problem Operating System: redhat linux 9 PHP Version: 4.3.10 New Comment: Sorry I didn't find it. Previous Comments: [2005-01-14 17:28:16] [EMAIL PROTECTED] Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Bug #30726 [2005-01-14 14:23:57] amonw at hotmail dot com Sorry, made a mistake. Expected result: 0.9 0.9 [2005-01-14 10:37:55] amonw at hotmail dot com Description: An numeric string between -1 and 0 and without a leading zero can't be converted correctly while php 4.2.2 can. Reproduce code: --- ?php print 1+-.1; $a=1; $b=-.1; print \n; print $a+$b; ? Expected result: -0.9 -0.9 Actual result: -- 1 1 -- Edit this bug report at http://bugs.php.net/?id=31548edit=1
#31548 [Csd-Opn]: old float conversion bug re-rised in newest CVS(php4-STABLE-200501150130)
ID: 31548 User updated by: amonw at hotmail dot com -Summary: 1+-.1 produce 1 Reported By: amonw at hotmail dot com -Status: Closed +Status: Open Bug Type: Scripting Engine problem Operating System: redhat linux 9 -PHP Version: 4.3.10 +PHP Version: php-4.3.x CVS New Comment: But it still exists in the newest CVS(php4-STABLE-200501150130). Previous Comments: [2005-01-15 03:21:21] amonw at hotmail dot com Sorry I didn't find it. [2005-01-14 17:28:16] [EMAIL PROTECTED] Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Thank you for your interest in PHP. Bug #30726 [2005-01-14 14:23:57] amonw at hotmail dot com Sorry, made a mistake. Expected result: 0.9 0.9 [2005-01-14 10:37:55] amonw at hotmail dot com Description: An numeric string between -1 and 0 and without a leading zero can't be converted correctly while php 4.2.2 can. Reproduce code: --- ?php print 1+-.1; $a=1; $b=-.1; print \n; print $a+$b; ? Expected result: -0.9 -0.9 Actual result: -- 1 1 -- Edit this bug report at http://bugs.php.net/?id=31548edit=1
#31222 [Asn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com Status: Assigned Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 Assigned To: tony2001 New Comment: Hi, Are you still there? Would you check it out pls? Previous Comments: [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] [EMAIL PROTECTED] 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] [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. 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=31222edit=1
#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 New Comment: Just in case, did you receive my email with a test account? I sent it about 8 hours ago. Previous Comments: [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. [2004-12-21 10:48:21] [EMAIL PROTECTED] I can't reproduce it with any of PHP versions and Oracle 9.2. Did you try to run this code using PHP-CLI? Does it work for you? 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=31222edit=1
#31222 [Asn]: ocicommit not working
ID: 31222 User updated by: amonw at hotmail dot com Reported By: amonw at hotmail dot com Status: Assigned Bug Type: OCI8 related Operating System: redhat linux 7.2 PHP Version: 4.3.10 Assigned To: tony2001 New Comment: 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? Previous Comments: [2004-12-23 18:16:12] [EMAIL PROTECTED] 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] [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. 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=31222edit=1
#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
New Comment:
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.
Previous Comments:
[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.
[2004-12-21 10:48:21] [EMAIL PROTECTED]
I can't reproduce it with any of PHP versions and Oracle 9.2.
Did you try to run this code using PHP-CLI?
Does it work for you?
[2004-12-21 08:31:53] amonw at hotmail dot com
Description:
ocicommit not working in the following code when connected to oracle
8.1.7 .
The oddest thing is I can avoid this by doing any one of the
following:
1. don't use the user defined function query, and used it's content
to replace the function calls
or
2. use different veriable name for the two connections
or
3. use different veriable name for the two query results
or
4. add $statement=anything or unset($statement) before the second
$statement=query($c,$sql)
configure command(from phpinfo()):
'./configure' '--with-apxs' '--with-gd' '--with-oci8=shared'
'--with-zlib' '--with-jpeg-dir' '--enable-gd-native-ttf'
'--with-freetype-dir' '--with-ttf' '--enable-ftp'
Reproduce code:
---
?php
function query($conn,$sqlstr)
{
$statement=ociparse($conn,$sqlstr);
ociexecute($statement,OCI_DEFAULT);
return $statement;
}
dl('oci8.so');
$c=ocilogon('user','pwd');
$sql=select sysdate from dual;
$statement=query($c,$sql);
$c=ocilogon('user','pwd');
$sql=delete from info_user where device_number='1234567890';
$statement=query($c,$sql);
if(!ocicommit($c))
{
$error = OCIError($c);
echo 'Commit failed. Oracle reports: ' . $error['message'];
}
print($sql :.ocirowcount($statement).' records updated.');
?
Expected result:
Prints out delete from info_user where device_number='1234567890' :x
records deleted and
all records with device_number='1234567890' should be deleted.
Actual result:
--
Prints out delete from info_user where device_number='1234567890' :x
records deleted but no records was deleted.
--
Edit this bug report at http://bugs.php.net/?id=31222edit=1
#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
New Comment:
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.
Previous Comments:
[2004-12-21 10:48:21] [EMAIL PROTECTED]
I can't reproduce it with any of PHP versions and Oracle 9.2.
Did you try to run this code using PHP-CLI?
Does it work for you?
[2004-12-21 08:31:53] amonw at hotmail dot com
Description:
ocicommit not working in the following code when connected to oracle
8.1.7 .
The oddest thing is I can avoid this by doing any one of the
following:
1. don't use the user defined function query, and used it's content
to replace the function calls
or
2. use different veriable name for the two connections
or
3. use different veriable name for the two query results
or
4. add $statement=anything or unset($statement) before the second
$statement=query($c,$sql)
configure command(from phpinfo()):
'./configure' '--with-apxs' '--with-gd' '--with-oci8=shared'
'--with-zlib' '--with-jpeg-dir' '--enable-gd-native-ttf'
'--with-freetype-dir' '--with-ttf' '--enable-ftp'
Reproduce code:
---
?php
function query($conn,$sqlstr)
{
$statement=ociparse($conn,$sqlstr);
ociexecute($statement,OCI_DEFAULT);
return $statement;
}
dl('oci8.so');
$c=ocilogon('user','pwd');
$sql=select sysdate from dual;
$statement=query($c,$sql);
$c=ocilogon('user','pwd');
$sql=delete from info_user where device_number='1234567890';
$statement=query($c,$sql);
if(!ocicommit($c))
{
$error = OCIError($c);
echo 'Commit failed. Oracle reports: ' . $error['message'];
}
print($sql :.ocirowcount($statement).' records updated.');
?
Expected result:
Prints out delete from info_user where device_number='1234567890' :x
records deleted and
all records with device_number='1234567890' should be deleted.
Actual result:
--
Prints out delete from info_user where device_number='1234567890' :x
records deleted but no records was deleted.
--
Edit this bug report at http://bugs.php.net/?id=31222edit=1
#31222 [NEW]: ocicommit not working
From: amonw at hotmail dot com
Operating system: redhat linux 7.2
PHP version: 4.3.10
PHP Bug Type: OCI8 related
Bug description: ocicommit not working
Description:
ocicommit not working in the following code when connected to oracle 8.1.7
.
The oddest thing is I can avoid this by doing any one of the following:
1. don't use the user defined function query, and used it's content to
replace the function calls
or
2. use different veriable name for the two connections
or
3. use different veriable name for the two query results
or
4. add $statement=anything or unset($statement) before the second
$statement=query($c,$sql)
configure command(from phpinfo()):
'./configure' '--with-apxs' '--with-gd' '--with-oci8=shared' '--with-zlib'
'--with-jpeg-dir' '--enable-gd-native-ttf' '--with-freetype-dir'
'--with-ttf' '--enable-ftp'
Reproduce code:
---
?php
function query($conn,$sqlstr)
{
$statement=ociparse($conn,$sqlstr);
ociexecute($statement,OCI_DEFAULT);
return $statement;
}
dl('oci8.so');
$c=ocilogon('user','pwd');
$sql=select sysdate from dual;
$statement=query($c,$sql);
$c=ocilogon('user','pwd');
$sql=delete from info_user where device_number='1234567890';
$statement=query($c,$sql);
if(!ocicommit($c))
{
$error = OCIError($c);
echo 'Commit failed. Oracle reports: ' . $error['message'];
}
print($sql :.ocirowcount($statement).' records updated.');
?
Expected result:
Prints out delete from info_user where device_number='1234567890' :x
records deleted and
all records with device_number='1234567890' should be deleted.
Actual result:
--
Prints out delete from info_user where device_number='1234567890' :x
records deleted but no records was deleted.
--
Edit bug report at http://bugs.php.net/?id=31222edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31222r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31222r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31222r=trysnapshot51
Fixed in CVS:http://bugs.php.net/fix.php?id=31222r=fixedcvs
Fixed in release:http://bugs.php.net/fix.php?id=31222r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31222r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31222r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31222r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31222r=support
Expected behavior: http://bugs.php.net/fix.php?id=31222r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31222r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31222r=submittedtwice
register_globals:http://bugs.php.net/fix.php?id=31222r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31222r=php3
Daylight Savings:http://bugs.php.net/fix.php?id=31222r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31222r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31222r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31222r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31222r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31222r=mysqlcfg
