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.
OCILob::save
(PHP 5, PHP 7, PHP 8, PECL OCI8 >= 1.1.0)
OCILob::save — Saves data to the large object
Description
OCILob::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.
Changelog
| Version | Description |
|---|---|
| 8.0.0, PECL OCI8 3.0.0 | The OCI-Lob class was renamed to OCILob to align with PHP naming standards. |
add a note
User Contributed Notes 2 notes
Anonymous ¶
18 years ago
Michael Krug ¶
11 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);
