php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #40648 oci_fetch_array hangs with OCI_FETCH_LOBS
Submitted: 2007-02-26 19:03 UTC Modified: 2007-03-06 01:00 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: miguel at withoutabox dot com Assigned:
Status: No Feedback Package: OCI8 related
PHP Version: 5.2.1 OS: Ubuntu Linux 6.06
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: miguel at withoutabox dot com
New email:
PHP Version: OS:

 

 [2007-02-26 19:03 UTC] miguel at withoutabox dot com
Description:
------------
When I try to do a oci_fetch_array with OCI_RETURN_LOBS in the  mode string the page hangs indefinitely.  No errors are produced but the page never even times out.  

OCI version is 1.2.3 from PECL


Reproduce code:
---------------
<?php

$db = "(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST=1.1.1.1)(PORT = 1521)))(CONNECT_DATA=(SID=FESTPROD)))";

$usr = "notreal";
$pwd = "itsfake";

$connection = oci_connect($usr, $pwd,$db);

$query = "SELECT * from CATEGORY where category_id=1111";

$statement = oci_parse($connection, $query);
oci_execute($statement);

while ($row = oci_fetch_array($statement, (OCI_ASSOC+OCI_RETURN_LOBS))) {
   echo $row['COMPLETE_RULES']."<br>";  //this will output LOB's content
}
?>

Expected result:
----------------
Lots of words ..........


.....end of words<br>

Actual result:
--------------
Page hangs

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-02-26 19:42 UTC] tony2001@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.


 [2007-03-02 20:15 UTC] christopher dot jones at oracle dot com
I could not reproduce this with 5.2.1 or 5.2.2 Dev (with patch for 40415)
 [2007-03-06 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 04:01:29 2024 UTC