If you are using Save() on an update statement, PHP will throw a warning similar to "OCILobWrite: OCI_INVALID_HANDLE..." if your update statement did not catch any rows with its where clause.
PHP - Manual: OCI-Lob::save
2024-12-27
(PHP 5, PHP 7, PECL OCI8 >= 1.1.0)
OCI-Lob::save — Saves data to the large object
$data
[, int $offset
] ) : bool
Saves data
to the large object.
data
The data to be saved.
offset
Can be used to indicate offset from the beginning of the large object.
成功时返回 TRUE
, 或者在失败时返回 FALSE
。
If you are using Save() on an update statement, PHP will throw a warning similar to "OCILobWrite: OCI_INVALID_HANDLE..." if your update statement did not catch any rows with its where clause.
When you get "OCI-Lob::save(): OCI_INVALID_HANDLE in ..." try
oci_execute($stid, OCI_NO_AUTO_COMMIT);
$clob->save($data);
oci_commit($conn);