How to fix the Oracle error OCI-22279: cannot perform operation with LOB buffering enabled?

In this post, you’ll learn more about the Oracle ErrorOCI-22279: cannot perform operation with LOB buffering enabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-22279: cannot perform operation with LOB buffering enabled

Reason for the Error OCI-22279: cannot perform operation with LOB buffering enabled

The operation attempted is not allowed when LOB buffering is enabled.

How to fix the Error OCI-22279: cannot perform operation with LOB buffering enabled ?

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

If the operation is required, LOB buffering should not be used. In this case, flush buffers associated with the input LOB locator as necessary, disable buffering on the input LOB locator and reissue the command.