Hi,
I need to parse XML response but response tags contain "xmlns=""" in them. I can parse the response if they are simple i.e. without "xmlns=""". I'm parsing them in PL/SQL. Below is sample XML response:
<
soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<LookupResponse xmlns="http://abc.net:8080/lrnsvc/">
<PhoneNumber xmlns="">2223311414</PhoneNumber>
<RoutingNumber xmlns="">2227210999</RoutingNumber>
<CallerID xmlns="">CENTER FOR ABC</CallerID>
<Location xmlns="">
<LATA xmlns="">430</LATA>
<Name xmlns="">ABCVILLE</Name>
<State xmlns="">CA</State>
</Location>
</LookupResponse>
</soap:Body>
</soap:Envelope>
If the tags are like: <PhoneNumber>2223311414</PhoneNumber>
<RoutingNumber>2227210999</RoutingNumber>
then I can parse them with below code and getting correct result.
strPhoneNo := UPPER (TRIM (SUBSTR (getValue (xmlResponseDoc2, '/PhoneNumber', strNameSpace), 1, 25)));
strRouteNo := UPPER (TRIM (SUBSTR (getValue (xmlResponseDoc2, '/RoutingNumber', strNameSpace), 1, 25)));
But if the tags are like below, I'm not sure how to parse them:
<PhoneNumber xmlns="">2223311414</PhoneNumber>
<RoutingNumber xmlns="">2227210999</RoutingNumber>
Appreciate & thanks for your help in advance.