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 JUNE 21, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.13.0.0.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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