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

In this post, you’ll learn more about the Oracle ErrorORA-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

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

Reason for the Error ORA-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 ORA-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.