Problem with CLOB

[riteshrm]

I have CLOB as one of my table field types. When I try to print the value, it gives something like Resource id #6. Someone help me out...

[svetbg]

$sql = "SELECT message FROM watchdog"; // message is of CLOB type
$parsed = oci_parse($c, $sql);

I.
if (oci_execute($parsed)) {
    $numrows = oci_fetch_all($parsed, $tmpArr, 0, 1000);
    for ($i=0; $i<$numrows; $i++) {
        echo $tmpArr["MESSAGE"][$i] . "\n";
    }
}

II.
if (oci_execute($parsed)) {
    while ($row = oci_fetch_array($parsed, OCI_ASSOC)) {  
        $result = $row["MESSAGE"];
        echo $result->load() . "\n";
    }
}