ORA-22990 While Inserting Empty BLOBS To Return BLOB Locators After a Commit
(Doc ID 1020390.102)
Last updated on FEBRUARY 03, 2022
Applies to:PL/SQL - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!