APEX

Hi All,

I am able to parse the XML file which is having one parent node under one child node. Incase if Multi child node how can reterive the columns using apex_data_parse.parse().

@carsten-czarski-oracle Can you help on this.

Eg, Multi Child Node.

<?xml version="1.0" ?>
<employees>
  <employee>
    <empno>123</empno>
    <ename>SMITH</ename>
    <job>CLERK</job>
    <hiredate>17-DEC-1980</hiredate>
    <contacts>
      <contactTier>
        <contactId>100</contactId>
        <contactName>JOE BLOW</contactName>
      </contactTier>
      <contactTier>
        <contactId>200</contactId>
        <contactName>MARY JANE</contactName>
      </contactTier>
    </contacts>
  </employee>
  <employee>