The following is the ORA-22278 error message, you can learn the cause and solution of the Oracle database error.


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

Cause: 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.

Solution: 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.

Case:

Please wait for the update…