Home » Developer & Programmer » JDeveloper, Java & XML » How to extract xml data from a clob stored in a table? (Oracle 10g)
How to extract xml data from a clob stored in a table? [message #425860] Mon, 12 October 2009 12:04 Go to next message
mr_hotshot_818
Messages: 25
Registered: October 2009
Junior Member

I'm trying to extract xml data stored in a clob in an oracle table. Can you extract this data using pl/sql? Does anyone have an example? Found some incomplete examples on the web?
Re: How to extract xml data from a clob stored in a table? [message #425865 is a reply to message #425860] Mon, 12 October 2009 12:26 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
Many in this forum just read them.
Did you?

Regards
Michel
Re: How to extract xml data from a clob stored in a table? [message #425866 is a reply to message #425860] Mon, 12 October 2009 13:00 Go to previous messageGo to next message
mr_hotshot_818
Messages: 25
Registered: October 2009
Junior Member

Yes. I've been browsing the forum. I found this one but it is incomplete

=> How can i took xml field data form clob clumn directly ?


I ends with a block of sql ... is there follow up thread?
Re: How to extract xml data from a clob stored in a table? [message #425870 is a reply to message #425866] Mon, 12 October 2009 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know which one it is.
I don't know what EXACTLY you want to do.

Regards
Michel
Re: How to extract xml data from a clob stored in a table? [message #425874 is a reply to message #425860] Mon, 12 October 2009 13:38 Go to previous messageGo to next message
mr_hotshot_818
Messages: 25
Registered: October 2009
Junior Member

I'm interfacing data between two databases. I need to extract the xml data stored in a clob and then load the parsed data into a different Oracle table.


I've been experimenting with xmltable and extract. Haven't been able to parse the data
Re: How to extract xml data from a clob stored in a table? [message #425876 is a reply to message #425874] Mon, 12 October 2009 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the following topics:
http://www.orafaq.com/forum/?SQ=5c9a719ccc7de001ffee19feb3c543f2&t=search&srch=xmlsequence&btn_submit=Search&field=al l&forum_limiter=&search_logic=AND&sort_order=DESC&author=

Regards
Michel
Re: How to extract xml data from a clob stored in a table? [message #425878 is a reply to message #425860] Mon, 12 October 2009 15:47 Go to previous messageGo to next message
mr_hotshot_818
Messages: 25
Registered: October 2009
Junior Member

Thanks! I'm following your link and reading through the examples.

The examples are pretty straight forward but I noticed the DOCTYPE tag is not included in the examples (the examples that I've read so far)

The data in the clob column appears as follows


(CLOB) <?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http //java.sun.com/dtd/properties.dtd">
<properties>
<comment>Comment</comment>
<entry key="@DemoLicense@">true</entry> ...


Will the additional DOCTYPE tag cause a problem when parsing?
Re: How to extract xml data from a clob stored in a table? [message #425900 is a reply to message #425878] Tue, 13 October 2009 00:02 Go to previous message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you try it?

Regards
Michel
Previous Topic: Problem Webutil WEBUTIL_FILE.FILE_SELECTION_DIALOG_INT will not work
Next Topic: Problem with XMLElement using cast&multiset null values
Goto Forum:
  


Current Time: Wed Sep 28 22:49:26 CDT 2016

Total time taken to generate the page: 0.13832 seconds