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.
OCI-Lob::save
(PHP 5, PHP 7, PECL OCI8 >= 1.1.0)
OCI-Lob::save — Saves data to the large object
Description
OCI-Lob::save
( string
$data
[, int $offset
] ) : bool
Saves data to the large object.
Parameters
-
data -
The data to be saved.
-
offset -
Can be used to indicate offset from the beginning of the large object.
Return Values
Returns TRUE on success or FALSE on failure.
add a note
User Contributed Notes 2 notes
Anonymous ¶
13 years ago
Michael Krug ¶
6 years ago
When you get "OCI-Lob::save(): OCI_INVALID_HANDLE in ..." try
oci_execute($stid, OCI_NO_AUTO_COMMIT);
$clob->save($data);
oci_commit($conn);
