ID: 37331 Updated by: [EMAIL PROTECTED] Reported By: jarismar_silva at adplabs dot com dot br -Status: Open +Status: Feedback Bug Type: OCI8 related Operating System: Windows XP Professional SP2 PHP Version: 5.1.4 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: ------------------------------------------------------------------------ [2006-05-05 17:55:21] jarismar_silva at adplabs dot com dot br Following is the sctructure of table used into the command showed on initial code. CREATE TABLE INTEGRATIONVALUE ( IMD_ID NUMBER(6) NOT NULL, ILV_CODE VARCHAR2(40) NOT NULL, XML_DATA CLOB, ) ------------------------------------------------------------------------ [2006-05-05 17:20:23] jarismar_silva at adplabs dot com dot br The same problem ocurr into linux server (for the same snipped code initiali posted). Apache error_log says: child pid 3294 exit signal Segmentation fault (11) The server is Suse Linux 2.6.5-7.244-smp The php configure command whas: './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--disable-debug' '--disable-ipv6' '--enable-force-cgi-redirect' '--with-zlib' '--enable-track-vars' '--enable-sigchild' '--with-tsrm-pthreads' '--without-mysql' '--with-oci8=/opt/oracle/product/10gR1' '--disable-rpath' '--enable-memory-limit' '--enable-inline-optimization' '--enable-xml' '--with-gd' '--with-jpeg-dir=/usr' '--enable-gd-native-ttf' '--with-mcrypt' '--with-mhash' '--with-curl' ------------------------------------------------------------------------ [2006-05-05 16:50:21] jarismar_silva at adplabs dot com dot br Description: ------------ Trying to load data from table with CLOB column using oci_fetch_array with combined values for mode, causes apache2 crash. Reproduce code: --------------- <?php $conn = oci_connect(<user>, <password>, <db>); $sSQL = "SELECT xml_data FROM integrationvalue WHERE imd_id = 1 AND ilv_code = 0612400006652"; $stmt = oci_parse($conn, $sSQL); oci_execute($stmt); var_dump($stmt); // show valid resource id $row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_LOBS); // <--- crash here echo '<pre>'; print_r($row); echo '</pre>'; ?> Expected result: ---------------- Must show the $stmt resource id on var_dump and and some string data into the $row array. Actual result: -------------- My Machine is an P4 Dual core cpu (hyper threading) 2.8 Ghz, 2 Gb Ram. The database is Oracle 10g. I'm using php_oci8.dll. The apache log says: Parent: child process exited with status 3221225477 -- Restarting. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37331&edit=1