2 Replies Latest reply: Jun 21, 2012 5:56 AM by nithril RSS

    Best way to extract XML value wiith an xpath

    nithril
      Hello,

      I wonder what is the best way to extract text value from XmlType with an xpath.

      I need to insert a row inside a table where the row's data come from xpath extractions of an XmlType. I do a lot of (approximative 20) :
      EXTRACTVALUE(var.myxmltype , '/an/xpath/to/extract/elem1').
      EXTRACTVALUE(var.myxmltype , '/an/xpath/to/extract/elemI').
      EXTRACTVALUE(var.myxmltype , '/an/xpath/to/extract/elem20').

      inside the insert statement

      Is this way is the best or is there a more optimal way ?

      For example extracting the node '/an/xpath/to/extract/' and sarting from this node extracting "elem1", ... , "elemI", "elemN" children.

      Thanks for your help,

      Regards,

      Nicolas