OCI_DEFAULT for execute command to delay execution OCIExecute( $stmt, OCI_DEFAULT); / / for retrieve data use (after fetch): $result = OCIResult($stmt, $n); if (is_object ($result)) $result = $result - load(); / / For INSERT or UPDATE statement use: $sql = "insert into table (field1, field2) values (field1 = 'value', field2 = empty_clob()) returning field2 into :field2"; OCIParse($conn, $sql); $clob = OCINewDescriptor($conn, OCI_D_LOB); OCIBindByName ($stmt, ":field2", $clob, -1, OCI_B_CLOB); OCIExecute($stmt, OCI_DEFAULT); $clob - save ("some text"); OCICommit($conn);?
OCICollTrim