Forum Stats

  • 3,782,315 Users
  • 2,254,637 Discussions
  • 7,880,045 Comments

Discussions

APEX_DATA_PARSER.parse and complex XML

tdobe
tdobe Member Posts: 116 Blue Ribbon

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...

Tagged: