Inserting NULL into BLOB Column via OCI Results in Empty Blob When Supplemental Log Data Is Enabled
(Doc ID 2878078.1)
Last updated on JUNE 21, 2022
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Insert of NULL value into a BLOB column results in inserting an empty BLOB when SUPPLEMENTAL LOG DATA is enabled. The same code inserts NULL value as expected when SUPPLEMENTAL LOG DATA is disabled. The issue can be demonstrated using the steps mentioned below :
a. Create a demo table with BLOB column.
Observation :- All BLOB values are empty(instead of NULL) except for COL1=5.
The RDBMS version is upgraded to 19c. The issue is not observed in 12.1, 12.2 or 18c.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document