My Oracle Support Banner

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

Last updated on JULY 20, 2024

Applies to:

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


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


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.