Home » Developer & Programmer » JDeveloper, Java & XML » help with xml parsing (Oracle Database 11.2.0.2.0)
help with xml parsing [message #610386] Wed, 19 March 2014 12:29 Go to next message
Roger22
Messages: 98
Registered: April 2009
Location: Brasov, ROMANIA
Member
Hi,
I have the following xml:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">  
      <soapenv:Body>  
        <cdm:RoutingService_Response xmlns:cdm="http://www.accenture.com/RTc/OI/cdm">  
          <cdm:OutputData>  
            <cdm:OrderAttributes>  
              <cdm:List>  
                <cdm:name>SERVICES</cdm:name>  
                <!-- structura listei este valabila pentru serviciile : DSL, VOIP, IPTV  -->  
                <cdm:List>  
                  <cdm:name>SERVICE</cdm:name>  
                  <cdm:value>DSL</cdm:value>  
                  <cdm:List>  
                    <cdm:name>TECHNOLOGY</cdm:name>  
                    <cdm:value>VDSL</cdm:value>  
                    <cdm:Attribute>  
                      <cdm:name>PORTS</cdm:name>  
                      <cdm:value>128</cdm:value>  
                    </cdm:Attribute>  
                    <cdm:Attribute>  
                      <cdm:name>BANDWIDTH</cdm:name>  
                      <cdm:value>50.0</cdm:value>  
                    </cdm:Attribute>  
                  </cdm:List>  
                  <cdm:List>  
                    <cdm:name>TECHNOLOGY</cdm:name>  
                    <cdm:value>VDSL</cdm:value>  
                    <cdm:Attribute>  
                      <cdm:name>PORTS</cdm:name>  
                      <cdm:value>128</cdm:value>  
                    </cdm:Attribute>  
                    <cdm:Attribute>  
                      <cdm:name>BANDWIDTH</cdm:name>  
                      <cdm:value>20.0</cdm:value>  
                    </cdm:Attribute>  
                  </cdm:List>  
          </cdm:List>  
                <cdm:List>  
                  <cdm:name>SERVICE</cdm:name>  
                  <cdm:value>IPTV</cdm:value>  
                  <cdm:List>  
                    <cdm:name>TECHNOLOGY</cdm:name>  
                    <cdm:value>IPTV_TECHN</cdm:value>  
                    <cdm:Attribute>  
                      <cdm:name>BANDWIDTH</cdm:name>  
                      <cdm:value>100.0</cdm:value>  
                    </cdm:Attribute>  
                  </cdm:List>  
                </cdm:List>  
                <!-- structura listei este valabila pentru TDM  -->  
                <cdm:List>  
                  <cdm:name>SERVICE</cdm:name>  
                  <cdm:value>TDM</cdm:value>  
                  <cdm:Attribute>  
                    <cdm:name>FREE_PORTS</cdm:name>  
                    <cdm:value>5</cdm:value>  
                  </cdm:Attribute>  
                  <cdm:Attribute>  
                    <cdm:name>FREE_PAIRS</cdm:name>  
                    <cdm:value>50</cdm:value>  
                  </cdm:Attribute>  
                </cdm:List>  
                <!-- structura listei este valabila pentru CABLE_TV -->  
                <cdm:List>  
                  <cdm:name>SERVICE</cdm:name>  
                  <cdm:value>CABLE_TV</cdm:value>  
                  <cdm:List>  
                    <cdm:name>TECHNOLOGY</cdm:name>  
                    <cdm:value>CATV_FTTH</cdm:value>  
                    <cdm:Attribute>  
                      <cdm:name>SERVICE_READY</cdm:name>  
                      <cdm:value>YES</cdm:value>  
                    </cdm:Attribute>  
                  </cdm:List>  
                </cdm:List>  
                <!-- structura listei este valabila pentru CDMA  -->  
                <cdm:List>  
                  <cdm:name>SERVICE</cdm:name>  
                  <cdm:value>CDMA</cdm:value>  
                  <cdm:Attribute>  
                    <cdm:name>SERVICE_COVERAGE</cdm:name>  
                    <cdm:value>100</cdm:value>  
                  </cdm:Attribute>  
                </cdm:List>  
              </cdm:List>  
            </cdm:OrderAttributes>  
            <cdm:Error>  
              <cdm:code>ERR_000</cdm:code>  
              <cdm:details>OK</cdm:details>  
            </cdm:Error>  
          </cdm:OutputData>  
        </cdm:RoutingService_Response>  
      </soapenv:Body>  
    </soapenv:Envelope>


Is it possible to parse this xml, so that the output of the query is similar to this: http://tinypic.com/r/2v7xnbo/8 (I have made the output manually) ?

I'm not sure if this is possible in this way..
Any help is appreciated Smile

Thanks!
Re: help with xml parsing [message #610410 is a reply to message #610386] Wed, 19 March 2014 19:16 Go to previous message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
Read this.

SY.
Previous Topic: oracle jdeveloper 12 c lov issue
Next Topic: jdk version issue on client
Goto Forum:
  


Current Time: Thu Mar 28 04:58:34 CDT 2024