xml to oracle conversion

views:

114

answers:

xml to oracle conversion

Hi,

I would like to know whether there are any tools which convert xml data into Oracle tables. I came across Altova's MapForce. But I am not sure whether I could use that for achieving this. Could someone suggest any other alternate option / or any help documentation of Mapforce which talks about this conversion.

Thanks, Shafi

+1 A:

In 10g, you can create an XMLType table and use SQL*Loader to load data into it.

See documentation for details.

Then you can fill pure relational tables with SQL statements.

Quassnoi 2009-08-04 12:44:27

The best material I've seen is two papers by Ken Atkins on "Getting XML into and out of Oracle using PL/SQL." There's a version on the ODTUG site (registered members, but registration is free) at http://www.odtug.com/apex/f?p=500:565:0:::::

Jim Hudson 2009-08-04 13:42:28

Hi Jim,The above mentioned link is not showing up any content even after I registered. Could you send the link again.

2009-08-05 06:30:57

Yeah, jumping into the middle of the ODTUG site isn't easy. So here's the detailed route: www.odtug.com, click on Tech Resources. In the "search by topic" area click on "PL/SQL". Enter "Atkins" in the search box and it'll be about the 4th item in the list.

Jim Hudson 2009-08-07 13:39:27

ansaurus

tags:

views:

answers:

xml to oracle conversion

related questions