CLOB memory leak
Posted: Mon Jan 03, 2005 1:41 am
hi there
I'm using Oracle CLOB in order to store some pretty large string but when I retrieve it back several times the web server crashes. I free all my objects the code is small and looks fine for me but it looks like there's some nasty memory leak that I can't spot. I'm using PHP 5 with Apache 1.3 and OCI functions. Here is the code:
10x in advance 
feyd | Help us, help you. Please use
I'm using Oracle CLOB in order to store some pretty large string but when I retrieve it back several times the web server crashes. I free all my objects the code is small and looks fine for me but it looks like there's some nasty memory leak that I can't spot. I'm using PHP 5 with Apache 1.3 and OCI functions. Here is the code:
Code: Select all
$conn = oci_connect("SERVICE_DEV", "SERVICE", "ORCL");
$query = "SELECT HTML FROM WC_ARCHIVE_WARRANTY_CARD WHERE ID = '{$_GET['id']}'";
$stmt = oci_parse($conn, $query);
oci_execute($stmt);
while (OCIFetchInto($stmt, $arr, OCI_ASSOC)) {
$html = ($arr['HTML']->load());
}
echo $html;
unset($html);
unset($arr);
oci_free_statement($stmt);
oci_close($conn);feyd | Help us, help you. Please use
Code: Select all
andCode: Select all
tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color]