Bug #51675 [Fbk]: OCIFetchInto
| From: | sixd@php.net | Date: | Thu, 29 Apr 2010 04:20:33 +0000 |
| Subject: | Bug #51675 [Fbk]: OCIFetchInto | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-150018@lists.php.net to get a copy of this message | ||
Edit report at http://bugs.php.net/bug.php?id=51675&edit=1
ID: 51675
Updated by: sixd@php.net
Reported by: miguelaabraham at gmail dot com
Summary: OCIFetchInto
Status: Feedback
Type: Bug
Package: OCI8 related
Operating System: Itanium IA64
PHP Version: 5.2.13
New Comment:
If you're using LOBS, try OCI8 1.4.1 from
http://pecl.php.net/package/oci8/1.4.1
(or use PHP 5.3.2+) The delayed LOB cleanout prior to this version is
known to
cause memory shortages for heavy LOB users. Also see
http://blogs.oracle.com/opal/2010/03/reducing_oracle_lob_memory_use.html
Previous Comments:
------------------------------------------------------------------------
[2010-04-27 17:32:01] johannes@php.net
Please provide a complete script including the SQL and table definition.
------------------------------------------------------------------------
[2010-04-27 16:40:43] miguelaabraham at gmail dot com
Description:
------------
function next_record()
{
if ($this->max_rows > 0)
if (count($this->records) >= $this->max_rows)
{
$this->max_reached = true;
return false;
}
$this->currentRecord = array();
return OCIFetchInto($this->stmt, $this->currentRecord,
OCI_ASSOC + OCI_RETURN_NULLS);
}
Actual result:
--------------
[Tue Apr 27 10:35:03 2010] [error] [client xx.x.xx.xxx] PHP Fatal error:
Allowed memory size of 1073741824 bytes exhausted (tried to allocate 76
bytes) in .....
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=51675&edit=1