aspose file tools*
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 Java 8 in Action this week in the Java 8 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
Author

how to get SYS.XMLTYPE with result set

darlene ween
Greenhorn

Joined: Sep 21, 2004
Posts: 1
hi,
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!
darlene
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1121

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

http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsp/xmltype/index.html

http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/9i_jdbc/XMLTypeSample/Readme.html

Good Luck,
Avi.
Jalal banaii
Greenhorn

Joined: Oct 11, 2004
Posts: 1
Hi darlene,
look at this. Its great!
https://cwisdb.cc.kuleuven.ac.be/ora10doc/appdev.101/b10790/xdb11jav.htm
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to get SYS.XMLTYPE with result set
 
Similar Threads
invalid name pattern: SYS.XMLTYPE
java.sql.SQLException: No more data to read from socket
how to retrieve data if the column has XML file
Having issue extracting text from xmltype
ORA-21700: object does not exist or is marked for delete