Oracle finally, there is a solution for you to insert a value of the clob type.

At the end of oracle, when you insert a clob type value to connect to Oracle in php, an error will be reported when you insert & gt; 4000 characters to the clob type field in the table: the string is too long. How can we solve this problem? Can you not use the storage methods discussed? The error message "bind" is displayed. who can bind the demo code? Thank you. ------ solution ------------------ & lt ;? Phpp oracle last Oh, then you insert the clob type value appears
When using php to connect to Oracle, if you insert data greater than 4000 characters into a clob field in the table, an error is returned: the string is too long.
How can we solve this problem?
Can you not use the storage methods discussed?
The error message "bind" is displayed. who can bind the demo code?
Thank you.

------ Solution --------------------

Putenv ("ORACLE_SID = sid1 ");
Putenv ("ORACLE_HOME =/u01/app/oracle/product/8.0.5 ");

$ Handle = ora_plogon ("SCOTT @ sid1", "TIGER") or die;
$ Cursor = ora_open ($ handle );
Ora_commitoff ($ handle );

$ Query = "SELECT * from emp ";
Ora_parse ($ cursor, $ query) or die;
Ora_exec ($ cursor );

Echo"

\n";
echo  "$query\n\n";
$numcols = 0;
while(ora_fetch($cursor)) {
   $numcols = ora_numcols($cursor);
   for ($column=0; $column < $numcols; $column++) {
       $data = trim(ora_getcolumn($cursor, $column));
       if($data ==  "") $data = "NULL";
       echo  "$data\t";
   }
   echo  "\n";
}
$numrows = ora_numrows($cursor);
echo  "\nROWS RETURNED: $numrows\n";
echo  "

\ N ";

Ora_close ($ cursor );

?>
(Points)