Finally, oracle, there is a solution for you to insert a value of the clob type-php Tutorial

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 ;? Phppu 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 ("[email protected]", "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)