Oracle Error OCI-22279: cannot perform operation with LOB buffering enabled

Oracle Error Message

OCI-22279: cannot perform operation with LOB buffering enabled

Reason for the Error

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

Solution

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.