wood burning stoves 2.0*
The moose likes JDBC and the fly likes how to get SYS.XMLTYPE with result set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to get SYS.XMLTYPE with result set" Watch "how to get SYS.XMLTYPE with result set" New topic

how to get SYS.XMLTYPE with result set

darlene ween

Joined: Sep 21, 2004
Posts: 1
i have a problem,
I have to read an (oracle 9i) database colum which uses SYS.XMLTYPE

won't work for that, and I also tried or .
does anyone have an idea how to get it?
thank you so much!
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1131

If you haven't already discovered them, perhaps these samples (from Oracle's OTN Web site will be of help:



Good Luck,
Jalal banaii

Joined: Oct 11, 2004
Posts: 1
Hi darlene,
look at this. Its great!
It is sorta covered in the JavaRanch Style Guide.
subject: how to get SYS.XMLTYPE with result set