ORA-22990 While Inserting Empty BLOBS To Return BLOB Locators After a Commit
Last updated on JULY 05, 2017
Applies to:PL/SQL - Version 126.96.36.199 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
Million Knowledge Articles and hundreds of Community platforms