Bug #51675 [Fbk]: OCIFetchInto

From: 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

« previous php.bugs (#150018) next »