Clob field inserted in Php+oracle is greater than 4000 bytes quoted string literal too long

Rt,google says that SQL statements are too long to be used in the form of bound variables. Project with Yii,so, I use Yii bindparam, but solved the newspaper character is too long, but the new error: can only bind to insert long column Long value.
Tangled in,, for help.

This issue has been closed due to:

Reply content:

Rt,google says that SQL statements are too long to be used in the form of bound variables. Project with Yii,so, I use Yii bindparam, but solved the newspaper character is too long, but the new error: can only bind to insert long column Long value.
Tangled in,, for help.

Digging graves. It took so long to find a solution by accident. The original Oracle official documentation has the method. Sweat...
Use the php_oci8 extension.
When inserting:

$sql = "INSERT into Mylobs          (id,mylob)        VALUES          (mylobs_id_seq. Nextval,empty_clob ())       returning          mylob into:mylob_loc "; $stmt = Oci_parse ($conn, $sql); $myLOB = Oci_new_ Descriptor ($conn, Oci_d_lob); Oci_bind_by_name ($stmt, ": Mylob_loc", $myLOB,-1, Oci_b_clob); Oci_execute ($stmt, Oci_ DEFAULT) or Die ("Unable to execute query\n"), $myLOB->save (' Mylob_loc '); Oci_commit ($conn); Oci_free_statement ($ stmt); $myLOB->free (); Oci_close ($conn);

Http://www.oracle.com/technetwork/art ...

