From: jarismar_silva at adplabs dot com dot br
Operating system: Windows XP Professional SP2
PHP version: 5.1.4
PHP Bug Type: OCI8 related
Bug description: oci_fetch_array makes Apache2 crash
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 bug report at http://bugs.php.net/?id=37331&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37331&r=trysnapshot44
Try a CVS snapshot (PHP 5.1):
http://bugs.php.net/fix.php?id=37331&r=trysnapshot51
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37331&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37331&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37331&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37331&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37331&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37331&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37331&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37331&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37331&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37331&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37331&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37331&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37331&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37331&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37331&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37331&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37331&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37331&r=mysqlcfg
