XML Database (MOSC)

MOSC Banner

Inserting XML data into a table.

edited Jan 14, 2010 3:58AM in XML Database (MOSC) 3 commentsAnswered
I receive the following XML data in a CLOB field:

<?xml version="1.0" encoding="UTF-8" ?>

<MyMsg xmlns="">

<Item name="John" surname="Chisholm" age="56" />

more items here

</MyMsg>

How can I insert this data into a normal Oracle table that has the three columns name, surname and age ??

Using DBMS_XMLSTORE???

If I modify the xml format to the classic <name>John</name> form, I can do it, but the data does not come in that form. It comes as a set of attributes. I have no control over that so must find a way to do the insert using the data as provided.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center