OraFAQ Forum: JDeveloper, Java & XML » load xml file in oracle table

Home » Developer & Programmer » JDeveloper, Java & XML » load xml file in oracle table (Oracle9i Release 9.2.0.5.0 - Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

load xml file in oracle table [message #416756]

Tue, 04 August 2009 04:30

rahul_bahulekar
Messages: 18
Registered: January 2007

Junior Member

Hi,

my requirement is to load the XML file [file size around 10 mb] into table.

sample XML data is -

- <Filings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="~\filings.xsd">
- <Entity>
<EntityID>00401890X</EntityID>
- <Filings>
<FilingDate>1998-09-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34676636</FilingID>
</Filings>
</Entity>
- <Entity>
<EntityID>00404120X</EntityID>
- <Filings>
<FilingDate>1998-06-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34641101</FilingID>
</Filings>
</Entity>
- <Entity>
<EntityID>00600730X</EntityID>
- <Filings>
<FilingDate>1998-09-16T00:00:00</FilingDate>
<FilingType>REVOK</FilingType>
<FilingID>34676636</FilingID>
</Filings>
</Entity>
- <Entity>

i have goolgled to load XML data to oracle table i come to know about XDLDOM, XDK.

Can some help me so that i can load this xml file into table.

Thankx,
Rahul

Report message to a moderator

Re: load xml file in oracle table [message #416762 is a reply to message #416756]

Tue, 04 August 2009 04:41

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

SQL*Loader can load XMLTypes.

Multiple examples are in Shouvik Basu's blog..

Once you have the XMLType in the Database you can extract the relational data. (Different examples also in the blog post.)

Report message to a moderator

Re: load xml file in oracle table [message #416764 is a reply to message #416762]

Tue, 04 August 2009 04:45

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

PS: Don't multi-post your question, I have deleted the other copies.

Report message to a moderator

Previous Topic:	Retrieve the project which belongs to logged on user
Next Topic:	how to install xdk_plsql_9_2_0_5_0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 20:19:29 CST 2024