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:
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,
)
Previous Comments:
------------------------------------------------------------------------
[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
