#40648 [Opn->Fbk]: oci_fetch_array hangs with OCI_FETCH_LOBS

ID: 40648 Updated by: tony2001@php.net Reported By: miguel at withoutabox dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Ubuntu Linux 6.06 PHP Version: 5.2.1 New Comment: Thank you for this bug report. To properly diagnose the problem, we need a backtrace to see what is happening behind the scenes. To find out how to generate a backtrace, please read http://bugs.php.net/bugs-generating-backtrace.php for *NIX and http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32 Once you have generated a backtrace, please submit it to this bug report and change the status back to "Open". Thank you for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2007-02-26 19:03:15] miguel at withoutabox dot com Description: ------------ When I try to do a oci_fetch_array with OCI_RETURN_LOBS in the mode string the page hangs indefinitely. No errors are produced but the page never even times out. OCI version is 1.2.3 from PECL Reproduce code: --------------- <?php $db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=1.1.1.1)(PORT = 1521)))(CONNECT_DATA=(SID=FESTPROD)))"; $usr = "notreal"; $pwd = "itsfake"; $connection = oci_connect($usr, $pwd,$db); $query = "SELECT * from CATEGORY where category_id=1111"; $statement = oci_parse($connection, $query); oci_execute($statement); while ($row = oci_fetch_array($statement, (OCI_ASSOC+OCI_RETURN_LOBS))) { echo $row['COMPLETE_RULES']."<br>"; //this will output LOB's content } ?> Expected result: ---------------- Lots of words .......... .....end of words<br> Actual result: -------------- Page hangs ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=40648&edit=1