Edit report at http://bugs.php.net/bug.php?id=36607&edit=1
ID: 36607 Comment by: jonswaff at gmail dot com Reported by: jreed at myers dot com Summary: default_prefetch problem w/ dbLinks Status: No Feedback Type: Bug Package: OCI8 related Operating System: Linux - 386 PHP Version: 5.1.2 New Comment: I encountered the same issue using OCI8 version 1.2.5 with PHP version 5.2.13. Changing oci8.default_prefetch to zero did fix the problem but was not desirable. I upgraded to OCI8 version 1.4.1 and all was solved. I know this issue is quite old, but am commenting anyway in hopes that I save someone some time troubleshooting. Previous Comments: ------------------------------------------------------------------------ [2006-05-12 13:15:53] php at contact dot ady dot ro Try applying a patch for Oracle Bug:3396162 ------------------------------------------------------------------------ [2006-03-20 01:00:04] 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". ------------------------------------------------------------------------ [2006-03-12 09:04:28] tony2...@php.net >The same query works just fine when I run it within SQL*Plus. Sure. Because you don't use prefetching. >So this clearly leads to a problem with the PHP OCI8 driver. Please follow the advice from cjbj at hotmail dot com. ------------------------------------------------------------------------ [2006-03-10 18:39:19] jreed at myers dot com The same query works just fine when I run it within SQL*Plus. And the query works fine without the oci8.default_prefetch turned on. So this clearly leads to a problem with the PHP OCI8 driver. ------------------------------------------------------------------------ [2006-03-10 05:57:24] cjbj at hotmail dot com I'd contact Oracle Support about this. Give them the stack trace. There seems to be a couple of recent 10.2 reports to Oracle with a similar trace. ------------------------------------------------------------------------ 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/bug.php?id=36607 -- Edit this bug report at http://bugs.php.net/bug.php?id=36607&edit=1