3 Replies Latest reply: Jul 3, 2012 12:57 AM by odie_63 RSS

    Reading XML Through Oracle web service and updating the Database.

    942560
      Hi Experts,

      I am very new to Oracle XML programming ,it will be very appritiable if any one can guide me on my current requirement.
      I am working on oracle 11G Enterprise edition.

      I want to know the flow of steps with example to carry out certain task .
      Requirement:
      *1-Creating a web services with oracle 11G feature which will read a XML from another source.(Please guide the steps how to proceed on it)*
      2.Read the XML file into a clobe table.
      3.Update my underlying database table with the tag values.

      this is simple requirment as seems but as there is no one to guide on below steps i am looking for OTN help on this.

      I am attaching the sample XML which is to be parsed .

      <?xml version="1.0" encoding="UTF-8"?>
      <GSP xsi:noNamespaceSchemaLocation="../Schemas/ip_forms.xsd" xmlns:xsi="http://www.w2222.org/2001/XMLSchema-instance">
           <formData>
                <documentInformation>
                     <documentStatus>DRAFT</documentStatus>
                     <modificationTimestamp>20111220142230</modificationTimestamp>
                     <documentVersion>1.0</documentVersion>
                </documentInformation>
                <projectDescription>
                     <projectName>Shelter Construction</projectName>
                     <projectId>3bc5eb40-519e-44cc-ad92-efdfc08b8ee9</projectId>
                     <ttProjectName>text</ttProjectName>
                     <agreementNo>0000000249</agreementNo>
                     <ttAgreementNo>text</ttAgreementNo>
                     <implementer>Lutheran World Federation - LWF 1246004</implementer>
                     <ttImplementer>text</ttImplementer>
                     <operation>Chad</operation>
                     <ttOperation>text</ttOperation>
                     <sites>
                          <site>
                               <siteName>Farchana</siteName>
                               <siteId>3bc5eb40-519e-44cc-ad92-efdfc08b8ee9</siteId>
                               <target>410</target>
                               <value>text</value>
                          </site>
                          <site>
                               <siteName>Ameloyouna/Gaga</siteName>
                               <siteId>3bc5eb40-519e-44cc-ad92-efdfc08b8ee1</siteId>
                               <target>220</target>
                               <value>text</value>
                          </site>
                     </sites>
                     <ttSites>text</ttSites>
                     <budgetYear>2011</budgetYear>
                     <ttBudgetYear>text</ttBudgetYear>
                     <planningGroups>
                          <planningGroup>
                               <tpGroupName>Sudanese Refugees in the East </tpGroupName>
                               <tpGroupDescription>String</tpGroupDescription>
                               <demographicData>
                                    <ageGroups>
                                         <group_0-4>
                                              <male>
                                                   <numbers>2147483647</numbers>
                                              </male>
                                              <female>
                                                   <numbers>2147483647</numbers>
                                              </female>
                                         </group_0-4>
                                         <group_5-11>
                                              <male>
                                                   <numbers>2147483647</numbers>
                                              </male>
                                              <female>
                                                   <numbers>2147483647</numbers>
                                              </female>
                                         </group_5-11>
                                         <group_12-17>
                                              <male>
                                                   <numbers>2147483647</numbers>
                                              </male>
                                              <female>
                                                   <numbers>2147483647</numbers>
                                              </female>
                                         </group_12-17>
                                         <group_18-59>
                                              <male>
                                                   <numbers>2147483647</numbers>
                                              </male>
                                              <female>
                                                   <numbers>2147483647</numbers>
                                              </female>
                                         </group_18-59>
                                         <group_60>
                                              <male>
                                                   <numbers>2147483647</numbers>
                                              </male>
                                              <female>
                                                   <numbers>2147483647</numbers>
                                              </female>
                                         </group_60>
                                    </ageGroups>
                               </demographicData>
                               <majorSites>Farchana, Ameloyouna/Gaga</majorSites>
                          </planningGroup>
                     </planningGroups>
                     <ttPlanningGroups>text</ttPlanningGroups>
                     <periodAgreement>
                          <periodAgreementFrom>01.01.2011</periodAgreementFrom>
                          <periodAgreementTo>31.12.2011</periodAgreementTo>
                     </periodAgreement>
      </projectDescription>
      </formData>

      Thanks....