| XML parsing in pl/sql [message #352640] |
Wed, 08 October 2008 14:20  |
kanis
Messages: 61
Registered: November 2006
|
Member |
|
|
I have a xml like as below.
<?xml version="1.0" encoding="UTF-8" ?>
- <A>
- <B>
- <C>
- <D>
- <e>
- <DATA>
<VALUE>KOLKATA</VALUE>
</DATA>
</e>
</D>
- <D>
- <E>
- <DATA>
<VALUE>MUMBAI</VALUE>
</DATA>
</E>
</D>
</C>
</B>
</A>
--------------
I need to write down a procedure where my input will be only be only xpath.
now if my xpath //A//B/C/D/E/DATA/VALUE ,
I need two value 'KOLKATA' and 'MUMBAI' in my cursor.
How I can do that ?
I am new to this forum . Please guide/help me ?
|
|
|
|
|
|
|
|
| Re: XML parsing in pl/sql [message #352689 is a reply to message #352640] |
Thu, 09 October 2008 00:51  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| kanis wrote on Wed, 08 October 2008 21:20 |
I am new to this forum .
|
Registered: November 2006...
This is not so much an Oracle question as it is an XPath question. Try to find the proper XPath-expression first. There are plenty of very good sites out there explaining how to build an XPath-expression.
Then, once you got your XPath-expression, the Oracle part isn't so hard.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
