locked
Unable to Parse XML using Sp_XML_Prepare document when namespaces are present RRS feed

  • Question

  • Hi,

    I have an XML with namespaces. I am unable to parse it using sp_xml_preparedocument. I am able to parse if name spaces are removed from XML. Also I tried passing name spaces to Sp as parameter. But it is not returning any result.
    Below is the Namespaces node.

    '<SyncPurchaseOrder 
    xmlns="http://schema.inf.com/infOAGIS/2"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://schema.inf.com/infOAGIS/2 http://schema.inf.com/2.10.0/infOAGIS/BODs/Developer/SyncPurchaseOrder.xsd"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    releaseID="9.2"
    versionID="2.10.0"
    />'

    Thanks in Advance.

    Tuesday, July 5, 2016 11:10 AM

Answers

All replies