How to get XMLType column value from Oracle using JDBC ?

[Dennis Patel]

Hi,

Can anyone help me out how to get XMLType Column value from Oracle using JDBC. I'm unable to get the the CLOB.. Is there any other way to get the XMLType column value? Below is the query that i'm using..

"SELECT XMLCOLUMN FROM DATA_TABLE" - XMLCOLUMN is my XMLTYPE column..

Any help on this will be appreciated


Thanks,
Dee Kay

[Jan Cumps]

Welcome to JavaRanch!

[Dennis Patel]

Dee Kay wrote:Hi,

Can anyone help me out how to get XMLType Column value from Oracle using JDBC. I'm unable to get the the CLOB.. Is there any other way to get the XMLType column value? Below is the query that i'm using..

"SELECT XMLCOLUMN FROM DATA_TABLE" - XMLCOLUMN is my XMLTYPE column..

Any help on this will be appreciated


Thanks,
Dee Kay

Hi All,

I found the way to get this done.

[David O'Meara]

Posting links like this to your own site is called astroturfing and is not considered very nice

[Scott Selikoff]

Dennis Patel wrote:I found the way to get this done.

Why not post your solution here for others that might have the same problem?

[Sam Zou]

Scott Selikoff wrote:

Dennis Patel wrote:I found the way to get this done.

Why not post your solution here for others that might have the same problem?

True, you get information from forums but you have to share your knownledge too !