|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2006-08-18 20:35 UTC] tony2001@php.net
[2006-08-26 01:00 UTC] php-bugs at lists dot php dot net
[2006-09-29 18:48 UTC] peter dot oulman at uponor-usa dot com
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 17:00:01 2025 UTC |
Description: ------------ Versions of PHP newer than 5.1.2 (5.1.3/4/5) failed at loading a CLOB in a UTF-8 Oracle Database (tested with Oracle 10.2). There are neither exceptions thrown nor any other error messages are shown. The statement " echo $row[0]->load();" returns simply no output. Downgrading to version 5.1.2 resolves this, so this might be bug. Kind regards Thomas Adams Reproduce code: --------------- $sql='select ID, TEXT from TEST_CLOB'; // where Text is CLOB $stmt = oci_parse($connection, $sql); oci_execute($stmt) or die ("Unable to execute query\n"); $i=0; while ( $row = oci_fetch_array($stmt,OCI_NUM) ) { echo ($i+1) . " ". $row[0] ." : "; print $row[1]->load(); print " ... this is " . (is_object($row[1])?" an object ":" not an object "); print " ... object is " . (is_a($row[1],'OCI-Lob')?"a OCI-Lob ":"not a OCI-Lob "); print " ... class name of object is " . get_class($row[1]); print " ... vardump is "; var_dump($row); print '<br />'; $i++; } Expected result: ---------------- The "print $row[1]->load();" line should return the actual values from the select statement. Actual result: -------------- row[1]->load() returns nothing.