JSON_UTIL_PKG can generate invalid JSON when dbms_xmlgen.convert used

[eaolson]

I'm not sure what's going on here, but I'm guessing it has something to do with intermediate XML. It seems that a query with dbms_xmlgen.convert() in it can cause invalid JSON to be produced.

declare
  c clob;
begin
  c := alexandria.json_util_pkg.sql_to_json( 'select dbms_xmlgen.convert(''abc "def" hij'') as foo from dual' );
  dbms_output.put_line(c);
end;
/

Produces:

{"ROWSET":{"ROW":{"FOO":"abc "def" hij"}}}

Instead of:

{"ROWSET":{"ROW":{"FOO":"abc \"def\" hij"}}}