Filling An XMLTYPE Array Via Variable Assignment In PL/SQL Is Much Slower In 11.2.0.2 Than In Previous Versions (Doc ID 1484056.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

    v_xml_table(v_idx) := v_r_part.extract('/s/r');    
    v_xml_table.extend;                                               
     select v_r_part.extract('/s/r')
     into   v_xml_table(v_idx)

     from dual;

     v_xml_table.extend;
 

Changes

upgrade from Oracle Database 9i to 11.2

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