How to fix the Oracle error OCI-22278: must update the LOB only through the LOB buffers?

In this post, you’ll learn more about the Oracle ErrorOCI-22278: must update the LOB only through the LOB buffers with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-22278: must update the LOB only through the LOB buffers

Reason for the Error OCI-22278: must update the LOB only through the LOB buffers

LOB buffering is enabled for this LOB and there are buffers for this LOB in the buffer pool. Thus, updating the LOB through means other than the LOB buffers is not allowed.

How to fix the Error OCI-22278: must update the LOB only through the LOB buffers ?

You can fix this error in Oracle by following the below steps

Update the LOB through the LOB buffers using the locator that has LOB buffering enabled. If this operation is required, buffers associated with this LOB should either be flushed as necessary or buffering should be disabled. Once this is done, reissue the command.