Hi,
I have a XML response like below now I need to get Shipment attribute value from this XML type variable:
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
<env:Header>
<wsa:Action>http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentLineService/ShipmentLineService/AutocreateShipmentsResponse</wsa:Action>
<wsa:MessageID>urn:uuid:2f22b939-769c-4178-8706-9c613babd0f5</wsa:MessageID>
</env:Header>
<env:Body>
<ns0:AutocreateShipmentsResponse xmlns:ns0="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentLineService/types/">
<ns1:result xsi:type="ns0:AutocreateShipmentResponse" xmlns:ns0="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentLineService/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentLineService/types/">
<ns0:ReturnStatus>SUCCESS</ns0:ReturnStatus>
<ns0:MessageCount>0</ns0:MessageCount>
<ns0:Shipment>
<ns0:Shipment>60001</ns0:Shipment>
</ns0:Shipment>
</ns1:result>
</ns0:AutocreateShipmentsResponse>
</env:Body>
</env:Envelope>
I need SQL etc to extract: 60001 value from the above xml.
Regards,
Zahid Rahim