XMLLAGG function giving different results after upgrading from 11.2.0.3 to 12.1.0.2

(Doc ID 2315079.1)

Last updated on OCTOBER 06, 2017

Applies to:

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

Symptoms

On : 12.1.0.2 version, XML Database



Output format for the XMLAGG query is different on 12.1.0.2 than 11.2.0.4

SELECT XMLELEMENT (
  "actions",
  xmlattributes (
  'http://www.cigna.com/acme/messages/actions/2010/03' AS
"xmlns"),
  XMLAGG (ac.object_value))
  actionxml,
  ac.acme_mbr_id AS acme_cust_id
FROM action ac
WHERE ac.acme_mbr_id IN 'b24b288f-cb7f-11e0-a5d4-6b2909ef2d9d'
  AND ac.status NOT IN ('obsolete')
  GROUP BY ac.acme_mbr_id ;

 Setting the event and OFE parameter didn't help

alter session set events '44410 trace name context forever, level 1' ;
alter session set optimizer_features_enable="11.2.0.4";

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