Load .XML file using SQL*Loader [message #384912] |
Thu, 05 February 2009 13:51 |
rahul_bahulekar
Messages: 18 Registered: January 2007
|
Junior Member |
|
|
Hi,
I am looking for a solution to load .XML file in table using SQL*Loader. I have googled this but didn’t find any proper solutions.
My XML data is like (single record)–
- <Documents>
<Version>20011011</Version>
- <Document>
<TransType>Amendment</TransType>
<FilingMethod Method="Electronic" />
- <AmendmentActionLoop>
<AmendmentAction Action="NOAction" />
</AmendmentActionLoop>
- <AmendmentTypeLoop>
<AmendmentType Type="Continuation" />
</AmendmentTypeLoop>
<OriginalFileNumber>11111</OriginalFileNumber>
<LapseDate>20140624</LapseDate>
<FileNumber>111111</FileNumber>
<FileDate>20090123</FileDate>
<FileTime>00:16</FileTime>
<FilingOffice>WA DOL</FilingOffice>
<ActionCode />
<AltNameDesignation AltName="NOAltName" />
<AltFilingType AltType="NOAltType" />
<MiscInfo />
- <CurrentNames>
- <CurrentName>
- <Names>
<OrganizationName />
</Names>
</CurrentName>
</CurrentNames>
- <Debtors>
- <DebtorName>
- <Names>
<OrganizationName />
<MailAddress />
<City />
<State />
<PostalCode />
<County />
<Country />
<TaxID />
<OrganizationalType />
<OrganizationalJuris />
<OrganizationalID />
<Mark />
</Names>
<DebtorAltCapacity AltCapacity="NOAltCapacity" />
</DebtorName>
</Debtors>
- <Secured>
- <Names>
<OrganizationName />
<MailAddress />
<City />
<State />
<PostalCode />
<County />
<Country />
<TaxID />
<OrganizationalType />
<OrganizationalJuris />
<OrganizationalID />
<Mark />
</Names>
</Secured>
<Collateral />
- <AuthorizingParty>
- <AuthSecuredParty>
<OrganizationName>Bank of America, N.A.</OrganizationName>
</AuthSecuredParty>
- <AuthDebtor>
<OrganizationName />
</AuthDebtor>
</AuthorizingParty>
</Document>
From above XML I want to load FileNumber in a separate column and rest all the details in other column. Is it doable???
Thankx in advance,
Rahul.
|
|
|
|