Home » Developer & Programmer » JDeveloper, Java & XML » XML parsing in pl/sql (Oracle 10g)
XML parsing in pl/sql [message #352640] Wed, 08 October 2008 14:20 Go to next message
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 #352642 is a reply to message #352640] Wed, 08 October 2008 14:24 Go to previous messageGo to next message
kanis
Messages: 61
Registered: November 2006
Member
I am using oracle 10g.
please help.
Re: XML parsing in pl/sql [message #352688 is a reply to message #352640] Thu, 09 October 2008 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 57609
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search in the "JDeveloper, Java & XML" forum there are many examples.
Keywords: xmlelement, extractvalue, xmlsequence.

Regards
Michel
Re: XML parsing in pl/sql [message #352689 is a reply to message #352640] Thu, 09 October 2008 00:51 Go to previous message
Frank
Messages: 7877
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.
Previous Topic: XML Output help
Next Topic: Drag <div> holding data
Goto Forum:
  


Current Time: Fri Apr 18 05:45:26 CDT 2014

Total time taken to generate the page: 0.13424 seconds