8 Replies Latest reply: Apr 2, 2014 11:44 PM by San RSS

    Need load XML data into Oracle Table

    San

      Hi,

       

      I want to load 1.5 GB size XML data to Oracle table .

       

      My Oracle version is 10G

       

      My Sample XML Data

       

      <Dealer>

        <Id>10004</Id> is primary column , for 10004 i have address , contact and sales details , sales details will be multiple, now i need to create a table

       

      Some one please suggest is there anyway to do this?

       

        <?xml version="1.0" encoding="UTF-8" ?> 
      - <Dealers xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <Dealer>
        <Id>10004</Id> 
        <InternalId xsi:nil="true" /> 
        <LegalName xsi:nil="true" /> 
        <DbaName>A-P SUPER SERVICE, INC.</DbaName> 
        <Client>ALLY</Client> 
        <Frequency>30</Frequency> 
        <OutstandingBalance>705354.00</OutstandingBalance> 
        <Active>true</Active> 
        <GroupId xsi:nil="true" /> 
        <Tag>07</Tag> 
        <SecurityContext>045</SecurityContext> 
        <CreditLimit xsi:nil="true" /> 
        <RiskRating>8+</RiskRating> 
        <Comment xsi:nil="true" /> 
      - <PrimaryAccountManager>
        <Id>01</Id> 
        <InternalId xsi:nil="true" /> 
        <Name>UNKNOWN</Name> 
        <Title xsi:nil="true" /> 
        <BusinessPhone xsi:nil="true" /> 
        <CellPhone xsi:nil="true" /> 
        <Email xsi:nil="true" /> 
        </PrimaryAccountManager>
        <SecondaryAccountManagers xsi:nil="true" /> 
      - <PrimaryLocation>
        <Id>01</Id> 
        <InternalId xsi:nil="true" /> 
        <Name>A-P SUPER SERVICE, INC.</Name> 
        <Address1>338 N THIRD ST</Address1> 
        <Address2 xsi:nil="true" /> 
        <City>ROGERS CITY</City> 
        <State>MI</State> 
        <Zip>49779</Zip> 
        <County xsi:nil="true" /> 
        <Country xsi:nil="true" /> 
        <Latitude xsi:nil="true" /> 
        <Longitude xsi:nil="true" /> 
        <Phone>9897342941</Phone> 
        <Fax>9897343343</Fax> 
      - <PrimaryContact>
        <Id>01</Id> 
        <InternalId xsi:nil="true" /> 
        <Name>UNKNOWN</Name> 
        <Title xsi:nil="true" /> 
        <BusinessPhone xsi:nil="true" /> 
        <CellPhone xsi:nil="true" /> 
        <Email xsi:nil="true" /> 
        </PrimaryContact>
        <SecondaryContacts xsi:nil="true" /> 
        </PrimaryLocation>
        <SecondaryLocations xsi:nil="true" /> 
      - <Units>
      - <Unit>
        <Id>1C4NJDEB7ED740827</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4NJDEB7ED740827</SerialNumber> 
        <Year>2014</Year> 
        <Make>JEEP</Make> 
        <Model>COMPASS</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-04T00:00:00</FloorDate> 
        <FloorAmount>25344.00</FloorAmount> 
        <OutstandingBalance>25344.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-20T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C4NJRFB8ED799073</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4NJRFB8ED799073</SerialNumber> 
        <Year>2014</Year> 
        <Make>JEEP</Make> 
        <Model>PATRIOT</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-21T00:00:00</FloorDate> 
        <FloorAmount>24172.00</FloorAmount> 
        <OutstandingBalance>24172.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-21T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C4RDJDG8DC604750</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4RDJDG8DC604750</SerialNumber> 
        <Year>2013</Year> 
        <Make>DODG</Make> 
        <Model>DURANGO</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-10-02T00:00:00</FloorDate> 
        <FloorAmount>27965.00</FloorAmount> 
        <OutstandingBalance>25168.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>FA</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C6RR7GGXES144098</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C6RR7GGXES144098</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-02-27T00:00:00</FloorDate> 
        <FloorAmount>34268.00</FloorAmount> 
        <OutstandingBalance>34268.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C6RR7GT1ES219073</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C6RR7GT1ES219073</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-11-27T00:00:00</FloorDate> 
        <FloorAmount>39863.00</FloorAmount> 
        <OutstandingBalance>39863.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C6RR7KT7ES312137</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C6RR7KT7ES312137</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-07T00:00:00</FloorDate> 
        <FloorAmount>37962.00</FloorAmount> 
        <OutstandingBalance>37962.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-24T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2A8HR54P08R749355</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2A8HR54P08R749355</SerialNumber> 
        <Year>2008</Year> 
        <Make>CHRY</Make> 
        <Model>TOWN COUNTRY</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-12-02T00:00:00</FloorDate> 
        <FloorAmount>8435.00</FloorAmount> 
        <OutstandingBalance>8435.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>U</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C3CCACG3CH142608</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C3CCACG3CH142608</SerialNumber> 
        <Year>2012</Year> 
        <Make>CHRY</Make> 
        <Model>300</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2013-12-02T00:00:00</FloorDate> 
        <FloorAmount>14840.00</FloorAmount> 
        <OutstandingBalance>14840.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>U</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RC1BG2ER236662</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RC1BG2ER236662</SerialNumber> 
        <Year>2014</Year> 
        <Make>CHRY</Make> 
        <Model>TOWN COUNTRY</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-12-17T00:00:00</FloorDate> 
        <FloorAmount>30636.00</FloorAmount> 
        <OutstandingBalance>30636.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RC1BG5DR689365</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RC1BG5DR689365</SerialNumber> 
        <Year>2013</Year> 
        <Make>CHRY</Make> 
        <Model>TOWN COUNTRY</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-10-02T00:00:00</FloorDate> 
        <FloorAmount>21165.00</FloorAmount> 
        <OutstandingBalance>19048.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>FA</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>3C6JR7DT2EG241740</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>3C6JR7DT2EG241740</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-26T00:00:00</FloorDate> 
        <FloorAmount>29649.00</FloorAmount> 
        <OutstandingBalance>29649.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-26T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1B3CB3HA6BD106858</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1B3CB3HA6BD106858</SerialNumber> 
        <Year xsi:nil="true" /> 
        <Make xsi:nil="true" /> 
        <Model xsi:nil="true" /> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description /> 
        <FloorDate xsi:nil="true" /> 
        <FloorAmount>0.00</FloorAmount> 
        <OutstandingBalance>0.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate>2014-03-26T00:00:00</PayoffDate> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode xsi:nil="true" /> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">0</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C3CDZCG4DN687530</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C3CDZCG4DN687530</SerialNumber> 
        <Year>2013</Year> 
        <Make>DODG</Make> 
        <Model>AVENGER</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2013-10-30T00:00:00</FloorDate> 
        <FloorAmount>13965.00</FloorAmount> 
        <OutstandingBalance>11171.50</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>FA</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C4PJMCS3EW246710</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4PJMCS3EW246710</SerialNumber> 
        <Year>2014</Year> 
        <Make>JEEP</Make> 
        <Model>CHEROKEE</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-21T00:00:00</FloorDate> 
        <FloorAmount>29436.00</FloorAmount> 
        <OutstandingBalance>29436.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-21T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C4RJFAG3EC477904</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4RJFAG3EC477904</SerialNumber> 
        <Year>2014</Year> 
        <Make>JEEP</Make> 
        <Model>GR CHEROKEE</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-24T00:00:00</FloorDate> 
        <FloorAmount>34359.00</FloorAmount> 
        <OutstandingBalance>34359.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-24T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C6RR7FG7ES142150</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C6RR7FG7ES142150</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-09-10T00:00:00</FloorDate> 
        <FloorAmount>32138.00</FloorAmount> 
        <OutstandingBalance>32138.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C6RR7LG6ES308730</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C6RR7LG6ES308730</SerialNumber> 
        <Year>2014</Year> 
        <Make>RAM</Make> 
        <Model>TRUCK</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-13T00:00:00</FloorDate> 
        <FloorAmount>37613.00</FloorAmount> 
        <OutstandingBalance>37613.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-13T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C3KA43D29H611642</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C3KA43D29H611642</SerialNumber> 
        <Year>2009</Year> 
        <Make>CHRY</Make> 
        <Model>300</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2012-10-19T00:00:00</FloorDate> 
        <FloorAmount>10680.00</FloorAmount> 
        <OutstandingBalance>4975.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>U</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RC1BG7ER133480</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RC1BG7ER133480</SerialNumber> 
        <Year>2014</Year> 
        <Make>CHRY</Make> 
        <Model>TOWN COUNTRY</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-12-11T00:00:00</FloorDate> 
        <FloorAmount>29624.00</FloorAmount> 
        <OutstandingBalance>29624.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RDGBG9ER230454</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RDGBG9ER230454</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>CARAVAN</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-02-25T00:00:00</FloorDate> 
        <FloorAmount>24205.00</FloorAmount> 
        <OutstandingBalance>24205.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RDGCG2CR321948</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RDGCG2CR321948</SerialNumber> 
        <Year>2012</Year> 
        <Make>DODG</Make> 
        <Model>CARAVAN</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-03-07T00:00:00</FloorDate> 
        <FloorAmount>16765.00</FloorAmount> 
        <OutstandingBalance>10209.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>U</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RDGCG8ER345271</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RDGCG8ER345271</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>CARAVAN</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-03-24T00:00:00</FloorDate> 
        <FloorAmount>28469.00</FloorAmount> 
        <OutstandingBalance>28469.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">42</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-03-24T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>3C4PDCBG3ET133327</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>3C4PDCBG3ET133327</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>JOURNEY</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-08-30T00:00:00</FloorDate> 
        <FloorAmount>25378.00</FloorAmount> 
        <OutstandingBalance>25378.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>EI</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>5GAKRBED2BJ269900</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>5GAKRBED2BJ269900</SerialNumber> 
        <Year>2011</Year> 
        <Make>BUIC</Make> 
        <Model>ENCLAVE</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2013-12-17T00:00:00</FloorDate> 
        <FloorAmount>18917.50</FloorAmount> 
        <OutstandingBalance>18917.50</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>U</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C3CCBBBXDN584242</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C3CCBBBXDN584242</SerialNumber> 
        <Year>2013</Year> 
        <Make>CHRY</Make> 
        <Model>200</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2012-11-27T00:00:00</FloorDate> 
        <FloorAmount>22796.00</FloorAmount> 
        <OutstandingBalance>18236.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>EI</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C3CDFBB4ED682758</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C3CDFBB4ED682758</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>DART</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2013-11-12T00:00:00</FloorDate> 
        <FloorAmount>20464.00</FloorAmount> 
        <OutstandingBalance>20464.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode xsi:nil="true" /> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C3CDZAB7CN204652</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C3CDZAB7CN204652</SerialNumber> 
        <Year>2012</Year> 
        <Make>DODG</Make> 
        <Model>AVENGER</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2013-06-12T00:00:00</FloorDate> 
        <FloorAmount>12265.00</FloorAmount> 
        <OutstandingBalance>8584.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>FA</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">U</Item> 
        <Item Name="VtmsCode" Type="System.String" /> 
        <Item Name="VtmsDate" Type="System.DateTime" /> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C4PJMCSXEW203403</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C4PJMCSXEW203403</SerialNumber> 
        <Year>2014</Year> 
        <Make>JEEP</Make> 
        <Model>CHEROKEE</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-02-18T00:00:00</FloorDate> 
        <FloorAmount>30437.00</FloorAmount> 
        <OutstandingBalance>30437.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-02-27T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>2C4RDGCG6ER230085</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>2C4RDGCG6ER230085</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>CARAVAN</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>L</Description> 
        <FloorDate>2014-01-16T00:00:00</FloorDate> 
        <FloorAmount>28285.00</FloorAmount> 
        <OutstandingBalance>28285.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>LT</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine xsi:nil="true" /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String">LT</Item> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
      - <Unit>
        <Id>1C3CDZCB9EN116900</Id> 
        <InternalId xsi:nil="true" /> 
        <SerialNumber>1C3CDZCB9EN116900</SerialNumber> 
        <Year>2014</Year> 
        <Make>DODG</Make> 
        <Model>AVENGER</Model> 
        <Series xsi:nil="true" /> 
        <Color xsi:nil="true" /> 
        <Mileage xsi:nil="true" /> 
        <LocationId xsi:nil="true" /> 
        <StockId xsi:nil="true" /> 
        <Description>C</Description> 
        <FloorDate>2013-08-27T00:00:00</FloorDate> 
        <FloorAmount>23468.00</FloorAmount> 
        <OutstandingBalance>23468.00</OutstandingBalance> 
        <InvoiceNumber xsi:nil="true" /> 
        <MaturityDate xsi:nil="true" /> 
        <PayoffDate xsi:nil="true" /> 
        <PreviousStatus xsi:nil="true" /> 
        <FloorPlanCode>EI</FloorPlanCode> 
        <Comment xsi:nil="true" /> 
        <ProductLine /> 
        <ProductLineCategory xsi:nil="true" /> 
        <ProductLineDescription xsi:nil="true" /> 
        <Curtailments xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="IW_DAC_KEY" Type="System.Int32">33231</Item> 
        <Item Name="SecondaryCode" Type="System.String" /> 
        <Item Name="ManuallyFloored" Type="System.String" xsi:nil="true" /> 
        <Item Name="NewUsed" Type="System.String">N</Item> 
        <Item Name="VtmsCode" Type="System.String">50</Item> 
        <Item Name="VtmsDate" Type="System.DateTime">2014-01-30T00:00:00</Item> 
        <Item Name="BarsDeliveryDate" Type="System.DateTime" /> 
        </LaunchExtensions>
        </Custom>
        </Unit>
        </Units>
        <Charges xsi:nil="true" /> 
      - <Custom p7:Version="1.0" Schema="http://www.launchtechnologies.com/Integration/Service/Import/V3/Extension.xsd" xmlns:p7="http://www.launchtechnologies.com/Integration/schema/Entity/3.0/">
      - <LaunchExtensions xmlns="">
        <Item Name="InDefaultDate" Type="System.DateTime" /> 
        <Item Name="Sched_Restrict" Type="System.String" /> 
        <Item Name="FullUVE" Type="System.Boolean">false</Item> 
        <Item Name="HighLevelUVE" Type="System.Boolean">false</Item> 
        <Item Name="ExcludeSVA" Type="System.Boolean">true</Item> 
        <Item Name="ConcurrentAudit" Type="System.Boolean">false</Item> 
        <Item Name="CheckAllDemos" Type="System.Boolean">false</Item> 
        <Item Name="CheckAllTitles" Type="System.Boolean">false</Item> 
        <Item Name="CallBranch" Type="System.Boolean">false</Item> 
        <Item Name="TemporaryAuditComment" Type="System.String" /> 
        <Item Name="ReleaseDaysAfterFunding" Type="System.Int32" /> 
        <Item Name="FILLER" Type="System.Int32" /> 
        <Item Name="Cash_24_48_Hr" Type="System.Int32" /> 
        <Item Name="Lien_Payoff_Sched" Type="System.Boolean">false</Item> 
        <Item Name="Ally_Holds_Title_MCO" Type="System.Boolean">false</Item> 
        <Item Name="ReleaseDaysAfterSale" Type="System.Int32">3</Item> 
        </LaunchExtensions>
        </Custom>
        </Dealer>
      

       

       

      Cheers ,

      San

        • 1. Re: Need load XML data into Oracle Table
          Jason_(A_Non)

          What do you plan to do with this XML once you get it into the DB?

           

          Any chance to go to the 11g or 12c versions of the DB?  I ask simply because in 11.1 you gain a lot of advantages for working with XML in terms of performance and storage and that improves a bit more in 11.2.

          • 2. Re: Need load XML data into Oracle Table
            San

            Hi Jason,

             

            I just want to create a report based on the DB . Chance update DB version its really very less as of now. Since we are in process of moving servers.

             

            I don't have choice now .

            • 3. Re: Need load XML data into Oracle Table
              Jason_(A_Non)

              I just want to create a report based on the DB.

              Not following you.  Are you saying you simply want to load the XML into the DB and then run a SELECT statement against it to return a set of columns that can be displayed on some report ran by some tool?  Is this a one-time thing or to be repeated as the XML is updated.  Are you keeping old copies of the XML?  Just trying to understand.

              • 4. Re: Need load XML data into Oracle Table
                San

                you are 100% right. One time activity. this is my first archived data. 

                • 5. Re: Need load XML data into Oracle Table
                  Jason_(A_Non)

                  Sadly in 10g (are you 10.1 or 10.2), performance will be sub-par at best for trying to deal with such a large XML document.  Any way to shrink it by a reasonable % ahead of time by running it through a stylesheet to only keep the nodes/sections you need for the report?

                  Not sure if breaking it into smaller chunks will really get you where you need to go though.

                  http://www.liberidu.com/blog/2008/07/11/howto-load-really-big-xml-files/

                  • 6. Re: Need load XML data into Oracle Table
                    San

                    its 10.2 , you want me to install Oracle J developer?? no way to do through Pl/sql? i am worried . this is my first task.

                    • 7. Re: Need load XML data into Oracle Table
                      Jason_(A_Non)

                      How much, in terms of nodes or even which ones, are you needing to extract from the XML for this report?

                       

                      The problem with trying to parse this large XML in 10.2 is that it needs to read the entire XML into a DOM structure in memory.  That obviously uses a corresponding large amount of memory and then Oracle is still great when trying to parse/read this large memory structure.

                       

                      You might be better/faster served by parsing the XML outside the 10.2 DB and just storing into a standard relational table(s) what you need for your report.

                       

                      Others might have additional suggestions as well.

                      • 8. Re: Need load XML data into Oracle Table
                        San

                        Hope you have seen my Sample XML record, that is related to one dealer , i need to populate all the nodes, even if he have option to populate selected node that will also help.

                        for example

                        ID- 100004 contains many info like contacts, units now i need to do populate into DB , for single ID i too have many units child node ,

                         

                        from table i need to the selection. i have tried with

                         

                        CREATE OR REPLACE VIEW shan_v AS

                        SELECT *

                        FROM XMLTable('/Dealer'

                                PASSING XMLTYPE(

                                         bfilename('DEV_CSG_DIR','dealer2.xml')

                                        , nls_charset_id('AL32UTF8')

                                        )

                                        columns id           varchar2(10) path 'Id'

                                --,               dbaname     varchar2(30) path 'DbaName'

                               );

                         

                        But no luck , bcz my view doesnt have any data.

                         

                        even i tired with external tables but that was too complex with large xml.