ORA-22990 While Inserting Empty BLOBS To Return BLOB Locators After a Commit

(Doc ID 1020390.102)

Last updated on JULY 05, 2017

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.
***Checked for relevance on 03-Nov-2013***


The following error occurs while inserting empty blob to return blob locators.

ORA-22990: lob locator cannot span transaction

DML statements were executed within a for loop to insert an empty BLOB and an attempt to fetch is made followed by commit within the loop.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms