-
Unable to read XML for uploading in table
Hi,
I am having an xml file that I am not able to read properly. Below are the contents of my xml file:
I am not able to loop thru the tag with in the tag . I want to read the whole XML file like:
loop thru tag
...
...
...
loop thru tag
...
...
...
end loop tag
....
....
end loop tag
I am trying something like http://www.oracle-base.com/articles...Documents9i.php
Please help me to achieve this.
Thanks
-Pawan
-
[DOCUMENT DocNumber="IP00246" DocType="220" Version="2.00.02"][br /]
[SG03][br /]
[Currency][br /]
[CurrencyDetails CurrencyDetail.Q="Pound Sterling(826)" Currency.C="GBP"/][br /]
[/Currency][br /]
[/SG03][br /]
[S.SG08][br /]
[NameAndAddress Party.Q="SU"][br /]
[Reference][br /]
[Reference Reference.Q="AV" ReferenceNumber.D="31196"/][br /]
[/Reference][br /]
[br /]
[PartyIdentification PartyIdentification="DMS"/][br /]
[NameAndAddress NameAndAddress="XYX House"/][br /]
[NameAndAddress NameAndAddress="canville"/][br /]
[Street Country="GB"/][br /]
[br /]
[S.CTA.ContactInformation][br /]
[CommunicationContactCommunicationNumber="Dccc.pp@xyz.com"/][br /]
[/S.CTA.ContactInformation][br /]
[NameAndAddress][br /]
[br /]
[NameAndAddress Party.Q="BY"][br /]
[Reference][br /]
[Reference Reference.Q="AV" ReferenceNumber.D="21196"/][br /]
[/Reference][br /]
[Reference][br /]
[Reference Reference.Q="PV" ReferenceNumber.D="21196"/][br /]
[/Reference][br /]
[br /]
[PartyIdentification PartyIdentification="DMSB"/][br /]
[NameAndAddress NameAndAddress="XYX House"/][br /]
[NameAndAddress NameAndAddress="canville"/][br /]
[Street Country="GB"/][br /]
[br /]
[S.CTA.ContactInformation][br /]
[CommunicationContactCommunicationNumber="psi@xyz.com"/][br /]
[/S.CTA.ContactInformation][br /]
[NameAndAddress][br /]
[/S.SG08][br /]
[/DOCUMENT][br /]
[DOCUMENT DocNumber="IP00247" DocType="221" Version="2.00.02"][br /]
[SG03][br /]
[Currency][br /]
[CurrencyDetails CurrencyDetail.Q="Pound Sterling(826)" Currency.C="GBP"/][br /]
[/Currency][br /]
[/SG03][br /]
[S.SG08][br /]
[NameAndAddress Party.Q="SU"][br /]
[Reference][br /]
[Reference Reference.Q="AV" ReferenceNumber.D="31196"/][br /]
[/Reference][br /]
[br /]
[PartyIdentification PartyIdentification="DMS"/][br /]
[NameAndAddress NameAndAddress="XYX House"/][br /]
[NameAndAddress NameAndAddress="canville"/][br /]
[Street Country="GB"/][br /]
[br /]
[S.CTA.ContactInformation][br /]
[CommunicationContactCommunicationNumber="Dccc.pp@xyz.com"/][br /]
[/S.CTA.ContactInformation][br /]
[NameAndAddress][br /]
[br /]
[NameAndAddress Party.Q="BY"][br /]
[Reference][br /]
[Reference Reference.Q="AV" ReferenceNumber.D="21196"/][br /]
[/Reference][br /]
[Reference][br /]
[Reference Reference.Q="PV" ReferenceNumber.D="21196"/][br /]
[/Reference][br /]
[br /]
[PartyIdentification PartyIdentification="DMSB"/][br /]
[NameAndAddress NameAndAddress="XYX House"/][br /]
[NameAndAddress NameAndAddress="canville"/][br /]
[Street Country="GB"/][br /]
[br /]
[S.CTA.ContactInformation][br /]
[CommunicationContactCommunicationNumber="psi@xyz.com"/][br /]
[/S.CTA.ContactInformation][br /]
[NameAndAddress][br /]
[/S.SG08][br /]
[/DOCUMENT][br /]
[br /]
[br /]
I am not able to loop thru the tag [S.SG08] with in the tag [DOCUMENT]. I want to read the whole XML file like:[br /]
[br /]
loop thru [DOCUMENT] tag[br /]
...[br /]
...[br /]
...[br /]
loop thru [S.SG08] tag[br /]
...[br /]
...[br /]
...[br /]
end loop [S.SG08] tag[br /]
....[br /]
....[br /]
end loop [DOCUMENT] tag[br /]
-
Reading XML file
Hi,
I am sorry, I could not understand how to read the XML file
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|