My Oracle Support Banner

Inserting NULL into BLOB Column via OCI Results in Empty Blob When Supplemental Log Data Is Enabled (Doc ID 2878078.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.