How to fix the Oracle error OCI-22277: cannot use two different locators to modify the same LOB?

In this post, you’ll learn more about the Oracle ErrorOCI-22277: cannot use two different locators to modify the same LOB with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

OCI-22277: cannot use two different locators to modify the same LOB

Reason for the Error OCI-22277: cannot use two different locators to modify the same LOB

LOB buffering is enabled and an attempt was made to modify the LOB using two different LOB locators.

How to fix the Error OCI-22277: cannot use two different locators to modify the same LOB ?

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

When using LOB buffering, modify the LOB through one LOB locator only.