php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57073 Lob fields fetch truncated
Submitted: 2006-06-09 08:43 UTC Modified: 2006-07-07 06:50 UTC
From: max at e-kazan dot ru Assigned:
Status: Closed Package: oci8 (PECL)
PHP Version: 5.1.4 OS: RHEL AS 4 U2
Private report: No CVE-ID: None
 [2006-06-09 08:43 UTC] max at e-kazan dot ru
Description:
------------
PHP 5.1.4
oci8 1.2.1, compiled as shared
Oracle InstantClient 10.2
Oracle 10g

When I fetch LOB fields from DB using OCI-Lob->load() they come truncated


Reproduce code:
---------------
putenv('NLS_LANG=RUSSIAN_CIS.UTF8');
$con = oci_connect('username', 'password', '//db/sid');
$query = "SELECT * FROM news";
$stmt = oci_parse($con, $query);
oci_execute($stmt);
while ($row = oci_fetch_array($stmt, OCI_RETURN_NULLS))
{
	foreach ($row as $key => $value)
	{
		if (is_object($value) && get_class($value) == 'OCI-Lob')
			$value = $value->load();

		echo "$key => $value<br />";
	}
}

Expected result:
----------------
LOB fields not truncated

Actual result:
--------------
LOB fields are truncated

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-06-09 08:53 UTC] max at e-kazan dot ru
Extension was built as RPM with following options:

./configure --host=i686-redhat-linux-gnu --build=i686-redhat-linux-gnu --target=i686-redhat-linux --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --with-oci8=instantclient,/usr/lib/oracle/10.2.0.1/client/lib

make -j2
 [2006-06-09 08:54 UTC] max at e-kazan dot ru
oci8 v1.2.0 seems not to have this problem with same OS and compilation options
 [2006-06-12 07:09 UTC] tony2001 at phpclub dot net
Please try CVS version (before reporting any issues).
 [2006-07-07 06:50 UTC] max at e-kazan dot ru
CVS version works fine, thanks
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 19 03:01:27 2024 UTC