XMLLAGG function giving different results after upgrading from to

(Doc ID 2315079.1)

Last updated on OCTOBER 06, 2017

Applies to:

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


On : version, XML Database

Output format for the XMLAGG query is different on than

  xmlattributes (
  'http://www.cigna.com/acme/messages/actions/2010/03' AS
  XMLAGG (ac.object_value))
  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="";


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