DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unable to read XML for uploading in table

  1. #1
    Join Date
    Jan 2006
    Posts
    5

    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    [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 /]

  3. #3
    Join Date
    Jan 2006
    Posts
    5

    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
  •  


Click Here to Expand Forum to Full Width