This discussion is archived
3 Replies Latest reply: Jul 2, 2012 10:57 PM by odie_63 RSS

Reading XML Through Oracle web service and updating the Database.

942560 Newbie
Currently Being Moderated
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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points