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 Android Security Essentials Live Lessons this week in the Android 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: 1121

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!
I agree. Here's the link: http://aspose.com/file-tools
subject: how to get SYS.XMLTYPE with result set
Similar Threads
java.sql.SQLException: No more data to read from socket
invalid name pattern: SYS.XMLTYPE
ORA-21700: object does not exist or is marked for delete
how to retrieve data if the column has XML file
Having issue extracting text from xmltype