oci & display clob

[loreyvt]

Hi everybody:

How can I retrieve and display clob???

Thanks in advance.

Lore

[Anon]

Hi there!

This should get you all the data from the clob column in your table!

$dblink = ocilogon("username", "password");
$query = ociparse($dblink, "select COLUMNNAME from TABLE");
ociparse($query);

ocifetchstatement($query, $result);

// $result now contains the clob data

print $result["COLUMNNAME"];

ocifreestatement($query);
ocilogoff($dblink);

Scheng

[loreyvt]

Scheng,

Thanks for your help, but I does not work!!

The function print does not work, but I tried with this:

$dblink = ocilogon("username", "password");
$query = ociparse($dblink, "select COLUMNNAME from TABLE");
ociparse($query);

ocifetchstatement($query, $result);

// $result now contains the clob data

$myresult = $result["COLUMNNAME"];
echo $myresult;

But the $myresult is empty!!!

Please helpppppppppppp!!!!!!!!!!!!!1111

[Anon]

I'm sorry this one line should read:

...
$dblink = ocilogon("username", "password");
$query = ociparse($dblink, "select COLUMNNAME from TABLE");
ociexecute($query);

ocifetchstatement($query, $result);
...

Scheng