ID: 37331 User updated by: jarismar_silva at adplabs dot com dot br Reported By: jarismar_silva at adplabs dot com dot br Status: Open Bug Type: OCI8 related Operating System: Windows XP Professional SP2 PHP Version: 5.1.4 New Comment:
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' Previous Comments: ------------------------------------------------------------------------ [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