APEX_DATA_PARSER.parse and complex XML

tdobe

Hi,

I have XML:

<list>

<product>

<availabilityCount>41.0000</availabilityCount>

<indexCatalogue>PR01</indexCatalogue>

<attributes>

<attribute eid="80140">

<name> width </name>

<value>100</value>

</attribute>

<attribute eid="80121">

<name>Height</name>

<value>17</value>

</attribute>

</attributes>

</product>

<product>

<availabilityCount>40.0000</availabilityCount>

<indexCatalogue>PR02</indexCatalogue>

<attributes>

<attribute eid="80140">

<name> width </name>

<value>120</value>

</attribute>

<attribute eid="80121">

<name>Height</name>

<value>27</value>

</attribute>

</attributes>

</product>

</list>

How to read attributes with APEX_DATA_PARSER.parse?

Now i have only:

select b.*

from table pl,  

table(APEX_DATA_PARSER.parse(

  p_content => pl.file_clob,

  P_FILE_NAME => pl.file_name

 )

) b

results:

LINIE NUMBER | COL001 | COL002 | COL003 | COL004 ...

1 41.0000 PR01 null null

2 40.0000 PR02 null null

i need acces to attributes with and height...