XML table left outer join COLLECTION ITERATOR PICKLER FETCH

 Hi,

My schema:

DECLARE

  doc CLOB:= 

   to_clob ( '<?xml version="1.0" encoding="UTF-8"?>

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://local/Approval"

targetNamespace="http://local/Approval" elementFormDefault="qualified">

    <xs:complexType name="User_T">

        <xs:attribute name="name" type="xs:string" use="required"/>

        <xs:attribute name="fullName" type="xs:string"/>

    </xs:complexType>

    <xs:complexType name="ApprovalNode">

          <xs:choice maxOccurs="unbounded">

                  <xs:element ref="User" maxOccurs="unbounded"/>

                  <xs:element ref="Condition" minOccurs="0"/>

          </xs:choice>

          <xs:attribute name="id" type="xs:string" use="required"/>

          <xs:attribute name="label" type="xs:string"/>

    </xs:complexType>

    <xs:complexType name="Condition_T">

        <xs:attribute name="name" type="xs:string" use="required"/>