title: Need to read value of multiple node: ORA-19025: EXTRACTVALUE returns value of only one node
body: <p>I can successfully read from xml file : DataTransfer_HH_TWWholesale_001_004_12142020113003.xml
  which has only one node.</p>
  <p>But when I am trying to read  multiple node from xml file: DataTransfer_HH_TWWholesale_001_009_09282020103349.xml , I get errorORA-19025: EXTRACTVALUE returns value of only one node.</p>
  <p>How can I read values from multiple node?</p>
  <p>Below is my file and code:</p>
  <p>File: DataTransfer_HH_TWWholesale_001_004_12142020113003.xml</p>
  <pre><code>&lt;MeterReadsReplyMessage xmlns=&quot;http://www.emeter.com/energyip/amiinterface&quot;&gt;
  &lt;Header&gt;
      &lt;verb&gt;create&lt;/verb&gt;
      &lt;noun&gt;DTSMeterReads&lt;/noun&gt;
      &lt;revision&gt;2&lt;/revision&gt;
      &lt;source&gt;EIP&lt;/source&gt;
  &lt;/Header&gt;
  &lt;payload&gt;
          &lt;MeterReading&gt;
              &lt;ServiceDeliveryPoint&gt;
                  &lt;mRID&gt;901291331_0001&lt;/mRID&gt;
                  &lt;idType&gt;SDP_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/ServiceDeliveryPoint&gt;
              &lt;Meter&gt;
                  &lt;mRID&gt;SIE_640 C_310149563&lt;/mRID&gt;
                  &lt;idType&gt;METER_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/Meter&gt;
              &lt;IntervalBlock&gt;
                  &lt;readingTypeId&gt;LREG&lt;/readingTypeId&gt;
                  &lt;ReadingType&gt;
                      &lt;measurementType&gt;Register&lt;/measurementType&gt;
                      &lt;touBinNumber&gt;0&lt;/touBinNumber&gt;
                      &lt;unit&gt;L&lt;/unit&gt;
                      &lt;channelNumber&gt;1&lt;/channelNumber&gt;
                      &lt;direction&gt;Delivered&lt;/direction&gt;
                  &lt;/ReadingType&gt;
                  &lt;IReading&gt;
                      &lt;endTime&gt;2020-10-08T00:00:00.000Z&lt;/endTime&gt;
                      &lt;value&gt;0.0&lt;/value&gt;
                      &lt;quality&gt;
                          &lt;validationStatus&gt;EST&lt;/validationStatus&gt;
                          &lt;locked&gt;false&lt;/locked&gt;
                      &lt;/quality&gt;
                  &lt;/IReading&gt;
              &lt;/IntervalBlock&gt;
          &lt;/MeterReading&gt;
  
  &lt;/payload&gt;
  &lt;/MeterReadsReplyMessage&gt;
  </code></pre>
  <p>Code:</p>
  <pre><code>SELECT EXTRACTVALUE (VALUE (a1),'/Header/verb','xmlns=&quot;http://www.emeter.com/energyip/amiinterface')verb,
         EXTRACTVALUE (VALUE (a1),'/Header/noun','xmlns=&quot;http://www.emeter.com/energyip/amiinterface')noun,
         EXTRACTVALUE (VALUE (a1),'/Header/source','xmlns=&quot;http://www.emeter.com/energyip/amiinterface')source
        FROM xml_tab,TABLE (XMLSEQUENCE (EXTRACT (xml_data,
                                             '/MeterReadsReplyMessage/Header',
                                             'xmlns=&quot;http://www.emeter.com/energyip/amiinterface&quot;'
                                             ))) a1
   WHERE file_name = 'DataTransfer_HH_TWWholesale_001_004_12142020113003.xml';
  </code></pre>
  <p>Query:
  <a href="https://i.stack.imgur.com/KK9Xs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KK9Xs.png" alt="enter image description here" /></a>
  File: DataTransfer_HH_TWWholesale_001_009_09282020103349.xml</p>
  <pre><code>&lt;MeterReadsReplyMessage xmlns=&quot;http://www.emeter.com/energyip/amiinterface&quot;&gt;
  &lt;Header&gt;
      &lt;verb&gt;create&lt;/verb&gt;
      &lt;noun&gt;DTSMeterReads&lt;/noun&gt;
      &lt;revision&gt;2&lt;/revision&gt;
      &lt;source&gt;EIP&lt;/source&gt;
  &lt;/Header&gt;
  &lt;payload&gt;
          &lt;MeterReading&gt;
              &lt;ServiceDeliveryPoint&gt;
                  &lt;mRID&gt;901291331_0001&lt;/mRID&gt;
                  &lt;idType&gt;SDP_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/ServiceDeliveryPoint&gt;
              &lt;Meter&gt;
                  &lt;mRID&gt;SIE_640 C_310149563&lt;/mRID&gt;
                  &lt;idType&gt;METER_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/Meter&gt;
              &lt;IntervalBlock&gt;
                  &lt;readingTypeId&gt;LREG&lt;/readingTypeId&gt;
                  &lt;ReadingType&gt;
                      &lt;measurementType&gt;Register&lt;/measurementType&gt;
                      &lt;touBinNumber&gt;0&lt;/touBinNumber&gt;
                      &lt;unit&gt;L&lt;/unit&gt;
                      &lt;channelNumber&gt;1&lt;/channelNumber&gt;
                      &lt;direction&gt;Delivered&lt;/direction&gt;
                  &lt;/ReadingType&gt;
                  &lt;IReading&gt;
                      &lt;endTime&gt;2020-10-08T00:00:00.000Z&lt;/endTime&gt;
                      &lt;value&gt;0.0&lt;/value&gt;
                      &lt;quality&gt;
                          &lt;validationStatus&gt;EST&lt;/validationStatus&gt;
                          &lt;locked&gt;false&lt;/locked&gt;
                      &lt;/quality&gt;
                  &lt;/IReading&gt;
              &lt;/IntervalBlock&gt;
          &lt;/MeterReading&gt;
          &lt;MeterReading&gt;
              &lt;ServiceDeliveryPoint&gt;
                  &lt;mRID&gt;112448526_0001&lt;/mRID&gt;
                  &lt;idType&gt;SDP_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/ServiceDeliveryPoint&gt;
              &lt;Meter&gt;
                  &lt;mRID&gt;SCE_640 Concentric_310037947&lt;/mRID&gt;
                  &lt;idType&gt;METER_X_UDC_ASSET_ID&lt;/idType&gt;
              &lt;/Meter&gt;
              &lt;IntervalBlock&gt;
                  &lt;readingTypeId&gt;LREG&lt;/readingTypeId&gt;
                  &lt;ReadingType&gt;
                      &lt;measurementType&gt;Register&lt;/measurementType&gt;
                      &lt;touBinNumber&gt;0&lt;/touBinNumber&gt;
                      &lt;unit&gt;L&lt;/unit&gt;
                      &lt;channelNumber&gt;1&lt;/channelNumber&gt;
                      &lt;direction&gt;Delivered&lt;/direction&gt;
                  &lt;/ReadingType&gt;
                  &lt;IReading&gt;
                      &lt;endTime&gt;2015-12-21T01:00:00.000Z&lt;/endTime&gt;
                      &lt;value&gt;0.0&lt;/value&gt;
                      &lt;flags&gt;0&lt;/flags&gt;
                      &lt;quality&gt;
                          &lt;validationStatus&gt;VAL&lt;/validationStatus&gt;
                          &lt;locked&gt;false&lt;/locked&gt;
                      &lt;/quality&gt;
                  &lt;/IReading&gt;
              &lt;/IntervalBlock&gt;
          &lt;/MeterReading&gt;
          
  &lt;/payload&gt;
  &lt;/MeterReadsReplyMessage&gt;
  </code></pre>
  <p>query:</p>
  <p><a href="https://i.stack.imgur.com/3RcvN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3RcvN.png" alt="enter image description here" /></a></p>
  <p>Thanks for reading my question.</p>
  <p>Expected result:</p>
  <pre><code>mRID             mfg_serial_num               readingTypeId   measurementType   Read_time
  901291331_0001  SIE_640 C_310149563           LREG             Register         2020-10-08T00:00:00.000Z
  112448526_0001  SCE_640 Concentric_310037947  LREG             Register         2015-12-21T01:00:00.000Z
  </code></pre>