1 Reply Latest reply: Jan 16, 2013 6:36 AM by odie_63 RSS

    Extracting xmlnamespace in oracle

      Hi Gurus,

      we are getting xml files with different xmlnamespaces and we want to pass namespace value.

      below is the example xml file:

      <?xml version="1.0" encoding="UTF-8"?>
      <Feed xmlns="http://www.abc.com/xs/sbc/data/5.7" name="abc" extractDate="2012-12-07T06:08:00.272-06:00">
      <Article number="18" disabled="false" removed="false">

      xmlns (xmlns="http://www.abc.com/xs/sbc/data/5.7") value is not fixed it is changing in other file it is coming as (xmlns="http://www.abc.com/xs/sbc/data/5.2")

      please guide me the way for extracting the namespace and passing it.