From: crescentfreshpot at yahoo dot com
Operating system: WinXP
PHP version: 5.1.3
PHP Bug Type: OCI8 related
Bug description: loading CLOBs crashes php in oci8
Description:
------------
OCI-Lob->read()/load() crashes php when reading clobs.
using 10g instant client, oracle v10.1.0.2.0.
Works in 5.1.3RC2 and prior (prior to fix for bug #36934 ).
Reproduce code:
---------------
sql:
alter session set current_schema = scott;
create table lobtest (lobdata clob);
insert into lobtest (lobdata) values('data data data data data data data
data');
commit;
php:
error_reporting(E_ALL);
//oci_internal_debug(1);
// uncommenting above shows the script crashes at
// OCILobRead2 at (ext\oci8\oci8_lob.c:242)
// introduced in the fix for bug #36934
$conn = oci_connect('scott', 'tiger', 'xxx')
or die('Cannot connect');
$stmt = oci_parse($conn, "select lobdata from lobtest");
oci_execute($stmt);
list($lob) = oci_fetch_row($stmt);
oci_free_statement($stmt); // 5.1.2 crashes without this
if($lob) {
$data = $lob->read(256);
//$data = $lob->load(); // this fails too
var_dump($data);
$lob->free(); // 5.1.2 crashes without this
}
Expected result:
----------------
string(39) "data data data data data data data data"
Actual result:
--------------
php crash
--
Edit bug report at http://bugs.php.net/?id=37292&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37292&r=trysnapshot44
Try a CVS snapshot (PHP 5.1):
http://bugs.php.net/fix.php?id=37292&r=trysnapshot51
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37292&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37292&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37292&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37292&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37292&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37292&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37292&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37292&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37292&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37292&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37292&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37292&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37292&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37292&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37292&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37292&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37292&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37292&r=mysqlcfg