Hey fellas, here's a tricky one 4 u.
Using PHP5 with Apache2.0.49 under RedHat 9, connected with Oracle9.2.0.4
I connect to a table of my DB, do a simple select and try to display result.
Problem is that the field i try to get is an NCLOB.
here's my code :

$myCon = ocilogon("user","password","myDatabase");
$stmt = ociparse($myCon, "select myField from myTable");
    // myField is the NCLOBociexecute($stmt, OCI_DEFAULT);
?>
<table border="0" cellpadding="1" cellspacing="2" width="50%">
  <tr>
    <td align="center">myField</td>
  </tr>
<?
while (ociFetch($stmt)) {
?>
  <tr valign="top">
    <td>
      <pre>
<?
    $result = ociResult($stmt,1);
        if (is_object ($result)) {
            echo $result->load();
            // also tried : echo $result->read($result->size());
    }
?>
      </pre>
    </td>
<?
}
?>
  </tr>
</table>

And this is what i get :

Warning: OCI-Lob::read() [[u]function.read</u>]: OCILobRead: ORA-24806: LOB form mismatch in... (bla bla bla)

What the ????

Ok, now guys...your call.
show me wat U got ?

By the way :
- database in UTF-
- apache default charset : UTF-
- php default charset : UTF-

enjoy !

__________________
php/java developer
NTIC engineer

btw...
case you would've asked.
I -of course- enabled multiByte Strings in PHP and set properly NLS_LANG (=.AL32UTF8) ...

According 2 me, it cannot be done.
My way to do it is to re-create tables, changing the NCLOB in2 LONG (up to 2Go, that'd b enough 4 me)
and i say re-create and not alter because that wouldn't work fine ("kkblobr" exception...who defined that name ?)

If u think there must b a way...i'm all listening.

And 4 the Xperts, i know using LONG in this case would be deprecated, but seems better than using NCLOB...because it really feels "not precated yet".