ID: 25623
Updated by: [EMAIL PROTECTED]
Reported By: maoy at fjii dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Windows XP
PHP Version: 4.3.3
New Comment:
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?
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2003-09-21 22:38:20] maoy at fjii dot com
Description:
------------
Web Server: Apache 1.3.26
When I get value of a field as Clob type, it always cause memory leak.
Reproduce code:
---------------
<?php
$conn = ocilogon("username","password");
$query = "SELECT clob_fldname FROM tablename";
$stmt = OCIParse ($conn, $query);
OCIExecute($stmt, OCI_DEFAULT);
$result = OCIResult($stmt, "clob_fldname");
if (is_object ($result)) $result = $result->load();
?>
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=25623&edit=1
