#31039 [Opn->Fbk]: ocifetchstatement Crashes php when clob length is > 0 && < 3

ID: 31039 Updated by: tony2001@php.net Reported By: ahmad dot ali at eedo dot com -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Linux PHP Version: 4.3.8 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 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: ------------------------------------------------------------------------ [2004-12-09 17:44:11] ahmad dot ali at eedo dot com Description: ------------ THIS IS A CRITICAL bug that is related to 14702 bug but was never followed. Whenever your do a select statement on a clob field (on a linux box) that has a length of less then 3 characters but more then 0 it will crash php. If you need more info please email me at ahmad.ali@eedo.com. We have clients running on oracle and are now stuck with no solutions. Reproduce code: --------------- if(!$port) $port = '1521'; $tns = " (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=$host)(PORT=$port)))(CONNECT_DATA=(SID=$dbname)))"; $conn = ocilogon('xxxxx','xxxxx',$tns); $SQL = "SELECT MYCLOBFIELD FROM CLOBTABLE"; $Result = ociparse($conn,$SQL); while(ocifetchinto($result, &$resultarray, OCI_RETURN_NULLS + OCI_RETURN_LOBS)) { // It crashes before it even gets here } Expected result: ---------------- not too crash and return the result from ocifetchinto. Actual result: -------------- Page not found (PHP crashes) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31039&edit=1