Oracle Error ORA-22990: LOB locators cannot span transactions

Oracle Error Message

ORA-22990: LOB locators cannot span transactions

Reason for the Error

A LOB locator selected in one transaction cannot be used in a different transaction.

Solution

Re-select the LOB locator and retry the operation.