php 读取 oracle clob,在php+oracle中clob字段插入大于4000字节报string literal too long

挖坟。。隔了这么久，偶然找到了解决方法。。原来Oracle 官方文档就有方法。。汗。。。

使用 php_oci8扩展。

在插入时：$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);