XML Extraction in Oracle

See more:

XML

Oracle

C#3.5

Hi,

I have following xml as string and i have passed that string into oracle Store procedure from c# code. Help me to extract value from the below XML?

<?xml version="1.0" encoding="utf-16"?>
<DataSet>
  <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
      <xs:complexType>
        <xs:choice minOccurs="0" maxOccurs="unbounded">
          <xs:element name="Table1">
            <xs:complexType>
              <xs:sequence>
                <xs:element name="FIRSTNAME" type="xs:string" minOccurs="0" />
                <xs:element name="LASTNAME" type="xs:string" minOccurs="0" />
                <xs:element name="ID" type="xs:int" minOccurs="0" />
                <xs:element name="RELATED_ID" type="xs:int" minOccurs="0" />              
                <xs:element name="RELATIONSHIP" type="xs:string" minOccurs="0" />
              </xs:sequence>
            </xs:complexType>
          </xs:element>
        </xs:choice>
      </xs:complexType>
    </xs:element>
  </xs:schema>
  <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1">
    <NewDataSet>
      <Table1 diffgr:id="Table11" msdata:rowOrder="0" diffgr:hasChanges="inserted">
        <FIRSTNAME>CHARLES</FIRSTNAME>
        <LASTNAME>DOTSON</LASTNAME>
        <ID>147251</ID>
        <RELATED_ID>147425</RELATED_ID>      
      </Table1>
    </NewDataSet>
  </diffgr:diffgram>
</DataSet>