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

Reply via email to