#40648 [NEW]: oci_fetch_array hangs with OCI_FETCH_LOBS

[miguel at withoutabox dot com]

From: miguel at withoutabox dot com
Operating system: Ubuntu Linux 6.06
PHP version: 5.2.1
PHP Bug Type: OCI8 related
Bug description: oci_fetch_array hangs with OCI_FETCH_LOBS

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

--
Edit bug report at [url]http://bugs.php.net/?id=40648&edit=1[/url]
--
Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=40648&r=trysnapshot44[/url]
Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=40648&r=trysnapshot52[/url]
Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=40648&r=trysnapshot60[/url]
Fixed in CVS: [url]http://bugs.php.net/fix.php?id=40648&r=fixedcvs[/url]
Fixed in release: [url]http://bugs.php.net/fix.php?id=40648&r=alreadyfixed[/url]
Need backtrace: [url]http://bugs.php.net/fix.php?id=40648&r=needtrace[/url]
Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=40648&r=needscript[/url]
Try newer version: [url]http://bugs.php.net/fix.php?id=40648&r=oldversion[/url]
Not developer issue: [url]http://bugs.php.net/fix.php?id=40648&r=support[/url]
Expected behavior: [url]http://bugs.php.net/fix.php?id=40648&r=notwrong[/url]
Not enough info: [url]http://bugs.php.net/fix.php?id=40648&r=notenoughinfo[/url]
Submitted twice: [url]http://bugs.php.net/fix.php?id=40648&r=submittedtwice[/url]
register_globals: [url]http://bugs.php.net/fix.php?id=40648&r=globals[/url]
PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=40648&r=php3[/url]
Daylight Savings: [url]http://bugs.php.net/fix.php?id=40648&r=dst[/url]
IIS Stability: [url]http://bugs.php.net/fix.php?id=40648&r=isapi[/url]
Install GNU Sed: [url]http://bugs.php.net/fix.php?id=40648&r=gnused[/url]
Floating point limitations: [url]http://bugs.php.net/fix.php?id=40648&r=float[/url]
No Zend Extensions: [url]http://bugs.php.net/fix.php?id=40648&r=nozend[/url]
MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=40648&r=mysqlcfg[/url]

[tony2001@php.net]

ID: 40648
Updated by: [email]tony2001@php.net[/email]
Reported By: miguel at withoutabox dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Ubuntu Linux 6.06
PHP Version: 5.2.1
New Comment:

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
[url]http://bugs.php.net/bugs-generating-backtrace.php[/url] for *NIX and
[url]http://bugs.php.net/bugs-generating-backtrace-win32.php[/url] 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.




Previous Comments:
------------------------------------------------------------------------

[2007-02-26 19:03:15] 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


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40648&edit=1[/url]

[christopher dot jones at oracle dot com]

ID: 40648
Comment by: christopher dot jones at oracle dot com
Reported By: miguel at withoutabox dot com
Status: Feedback
Bug Type: OCI8 related
Operating System: Ubuntu Linux 6.06
PHP Version: 5.2.1
New Comment:

I could not reproduce this with 5.2.1 or 5.2.2 Dev (with patch for
40415)


Previous Comments:
------------------------------------------------------------------------

[2007-02-26 19:42:49] [email]tony2001@php.net[/email]

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
[url]http://bugs.php.net/bugs-generating-backtrace.php[/url] for *NIX and
[url]http://bugs.php.net/bugs-generating-backtrace-win32.php[/url] 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-02-26 19:03:15] 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


------------------------------------------------------------------------


--
Edit this bug report at [url]http://bugs.php.net/?id=40648&edit=1[/url]