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