ID: 25623
User updated by: maoy at fjii dot com
Reported By: maoy at fjii dot com
Status: Open
Bug Type: OCI8 related
Operating System: Windows XP
PHP Version: 4.3.3
New Comment:
I had a try to run the following code on windows and linux, it cause
memory leak on both platform. The size of memory leak depends on the
size of CLOB-field's value and record count.
<?php
$conn = ocilogon("username","password","sid");
$query = "SELECT CLOB_FldName FROM tablename";
$stmt = OCIParse ($conn, $query);
OCIExecute($stmt);
while(ocifetchinto($stmt, $arr,OCI_ASSOC)){
$result = $arr["CLOB_FldName"]->load();
ecco $result;
}
?>
Previous Comments:
------------------------------------------------------------------------
[2003-10-09 20:08:47] maoy at fjii dot com
I'm not able to compile a debug-build, but it's undoubted that the
function cause memory leak. Please help me as soon as possible.
I am looking forward to reply. Thank you very much.
------------------------------------------------------------------------
[2003-09-24 05:41:54] [EMAIL PROTECTED]
sorry, if the leak does not show on unix there's not much
i can do as i don't run windows.
can you compile a debug-build and see if php actually
complains about mem-leaks?
------------------------------------------------------------------------
[2003-09-22 06:04:55] maoy at fjii dot com
In fact, I tried to use following codes:
ocifetchinto($stmt, $arr,OCI_ASSOC);
$result = $arr["CLOB_FLDNAME"]->load();
but it always cause memory leak on Windows system. It doesn't cause
memory leak on Linux system.
By the way, running environment is:
Windows XP
Apache 1.3.26
PHP 4.3.3
Oracle 8.1.7
I am looking forward to reply.
------------------------------------------------------------------------
[2003-09-22 05:09:45] [EMAIL PROTECTED]
could you plz replace
$result = OCIResult($stmt, "clob_fldname");
if (is_object ($result)) $result = $result->load();
against:
ocifetchinto($stmt, $arr,OCI_ASSOC);
$result = $arr["CLOB_FLDNAME"]->load();
as this is the code i use all the time and it doesn't
(seem) to leak for me.
------------------------------------------------------------------------
[2003-09-21 22:55:48] maoy at fjii dot com
memory leak size relate with value of the field, it also increase along
with running times
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/25623
--
Edit this bug report at http://bugs.php.net/?id=25623&edit=1
