Edit report at http://bugs.php.net/bug.php?id=51675&edit=1
ID: 51675 Updated by: [email protected] 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] [email protected] 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
