ID: 41069 User updated by: brian dot kao at gateway dot com 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:
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. Previous Comments: ------------------------------------------------------------------------ [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? ------------------------------------------------------------------------ [2007-04-13 07:53:28] [EMAIL PROTECTED] See bug #36607. PHP doesn't care whether you access the database using dblink or directly, so it's obviously not PHP problem. ------------------------------------------------------------------------ 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
