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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: max at e-kazan dot ru
New email:
PHP Version: OS:

 

 [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

Pull Requests

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: Thu Dec 26 12:01:30 2024 UTC