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....