ID: 41069 Updated by: [EMAIL PROTECTED] Reported By: brian dot kao at gateway dot com Status: Bogus Bug Type: OCI8 related Operating System: linux PHP Version: 5.2.1 New Comment:
One potential workaround is to modify php_oci_statement_set_prefetch() in oci8_statement.c and comment out either the lines that set the prefetch memory limit, or comment out the lines that set the prefetch row limit. In my testing the crash only occurred when both memory and row limits were set (and you use a DB link and you have the right data to trigger the crash). Confirmation or contradiction welcome. Previous Comments: ------------------------------------------------------------------------ [2007-05-10 02:27:16] brian dot kao at gateway dot com Thanks to the help from Chirstopher Jones, an Oracle/PHP consultant, Oracle is logging a bug for this issue. For anyone having the same issue, the bug id is 6039623. Hopefully, Oracle will have a fix soon. ------------------------------------------------------------------------ [2007-04-20 07:13:23] [EMAIL PROTECTED] >Oracle has closed the SR stating that since the database link works >with sqlplus that the issue is with PHP which Oracle does not support. Are you sure SQLPlus uses the same client library? >The database does not need a patch since there is no issue with the >database link on the Oracle database side I'm aware of similar issues, see the last comment here: http://bugs.php.net/bug.php?id=36607 ------------------------------------------------------------------------ [2007-04-19 21:48:13] brian dot kao at gateway dot com Tony, Our Oracle DBA tried reporting this issue to Oracle Support, but they came back to us and say this is not an Oracle issue. Here's the message I've received from our Oracle DBA: "Oracle has closed the SR stating that since the database link works with sqlplus that the issue is with PHP which Oracle does not support. The database does not need a patch since there is no issue with the database link on the Oracle database side." Are you aware of any workaround for this issue? ------------------------------------------------------------------------ [2007-04-13 08:07:19] [EMAIL PROTECTED] >could this be a PHP OCI8 driver issue? I'm saying it knows nothing of dblink. >What is your recommendation for this issue, going to Oracle support? Yes. ------------------------------------------------------------------------ [2007-04-13 08:00:41] brian dot kao at gateway dot com could this be a PHP OCI8 driver issue? If I limit the number of records returned, the query would run without any issue. This only happens when running a large query over dblink. What is your recommendation for this issue, going to Oracle support? ------------------------------------------------------------------------ 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/41069 -- Edit this bug report at http://bugs.php.net/?id=41069&edit=1
