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 8.0.5.0 and laterInformation in this document applies to any platform.
Symptoms
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.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |