Appending Text to CLOB Field using OCI8

[ab5602]

I hope someone finds this code usefull. I finally figured out how to append text to a clob field in Oracle using the PHP OCI8 functions.

After searching through past discussions here I noticed several people have asked how to do this but received no working code samples...

---

$conn = OCILogon("username", "password");

$sql_string1 = "select myfield from mytable where x=1 for update";

$stmt = OCIParse($conn, $sql_string1);

OCIExecute($stmt, OCI_DEFAULT);

OCIFetchInto($stmt,&$lob1,OCI_ASSOC);

$sql_string2 = "update mytable set myfield = :myfield where x=1";

$stmt = OCIParse($conn, $sql_string2);

$myfield = $lob1["myfield"]->load() . "here is my new text to append";

OCIBindByName($stmt, ":myfield", &$myfield, -1);

OCIExecute($stmt, OCI_DEFAULT);

OCICommit($conn);

---