My Oracle Support Banner

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

Last updated on APRIL 29, 2020

Applies to:

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

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

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
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.