OraFAQ Forum: JDeveloper, Java & XML » How to extract xml data from a clob stored in a table?

Home » Developer & Programmer » JDeveloper, Java & XML » How to extract xml data from a clob stored in a table? (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to extract xml data from a clob stored in a table? [message #425860]

Mon, 12 October 2009 12:04

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?

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes.
Many in this forum just read them.
Did you?

Regards
Michel

Report message to a moderator

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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know which one it is.
I don't know what EXACTLY you want to do.

Regards
Michel

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

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?

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you try it?

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:05:20 CST 2024