Wrong Results on 18c &19c When Concatenating NULL/Empty CLOB with String (Doc ID 2663093.1)

Last updated on APRIL 29, 2020

Applies to:

Symptoms

Wrong results on 18c & 19c when concatenating NULL/empty CLOB with string.
Concatenating a NULL/empty CLOB with other strings get wrong result on 18c & 19c versus 12.2.

Lob concat from PL/SQL produces wrong results when :
1. The first argument of the concat operation is NULL;
2. The dest. lob is part of the concat operation as wel

Cause

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