From: emmanuel dot chauvet at sitel-fr dot com
Operating system: Linux 2.6.12
PHP version: 5.1.4
PHP Bug Type: OCI8 related
Bug description: Cannot read lob content using oci8 functions
Description:
------------
Since 5.1.2 -> 5.1.4 migration, we have a bug in the oci8 functions when
we want to display Oracle LOB.
Source code is working for 5.1.2 , not any more for 5.1.4 version.
Reproduce code:
---------------
$sql = "SELECT TEMPLATEID, LABEL, DESCRIPTION, HTML, TXT, CONTENTTYPE, BIN
FROM TEMPLATECONTENT WHERE TEMPLATEID='301' AND LOCALE='fr_FR'";
$stmt = oci_parse( $conn, $sql );
oci_execute( $stmt );
while( $row = oci_fetch_row( $stmt ) )
{
$reponse_type[2] = $row[2]->load();
}
Expected result:
----------------
Expects the content of the oracle lob
5.1.2 version -> content displayed OK
5.1.4 version -> no content displayed
--
Edit bug report at http://bugs.php.net/?id=37475&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=37475&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=37475&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=37475&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37475&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=37475&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37475&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37475&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37475&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37475&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37475&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=37475&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=37475&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37475&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37475&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37475&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37475&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37475&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37475&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37475&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37475&r=mysqlcfg
