My Oracle Support Banner

JSON data is case sensitive to JSON procedures in later 19c DBRUs (Doc ID 2995518.1)

Last updated on JANUARY 04, 2024

Applies to:

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

Symptoms

The JSON_OBJECT procedure used a plsql block returns different output after applying the 19.17 dbru or later.

declare
j_obj clob;
begin
select json_object(id, last_name) into j_obj
from (select sp_id id, sp_last_name last_name
from sp where ... );
dbms_output.put_line(to_char(j_obj));
end;

pre 19.17: {"ID":"929018030","LAST_NAME":"Sample"}
19:17+: {"id":"929018030","last_name":"Sample"}

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


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