How to fix the Oracle error OCI-22282: non-contiguous append to a buffering enabled LOB not allowed?

In this post, you’ll learn more about the Oracle ErrorOCI-22282: non-contiguous append to a buffering enabled LOB not allowed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-22282: non-contiguous append to a buffering enabled LOB not allowed

Reason for the Error OCI-22282: non-contiguous append to a buffering enabled LOB not allowed

The buffered write operation has an input offset value more than one byte or character past the end of the LOB.

How to fix the Error OCI-22282: non-contiguous append to a buffering enabled LOB not allowed ?

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

Specify an input offset value which is exactly one character or byte greater than the length of the LOB that you are attempting to update through a buffered write operation.