JSON_ARRAYAGG Does Not Properly Escape Backslashes Or Double Quotes

(Doc ID 2346569.1)

Last updated on JANUARY 08, 2018

Applies to:

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

Symptoms

In 12.2, JSON_ARRAYAGG does not escape backslash and quotation characters, see below query output where elements 2 and 3 contain an unescaped \ character and element 4 contains unescaped " characters:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms