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:

Symptoms

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.

Changes

The RDBMS version is upgraded to 19c. The issue is not observed in 12.1, 12.2 or 18c.

Cause

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