aspose file tools*
The moose likes JDBC and the fly likes Reading UDT values using JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Reading UDT values using JDBC" Watch "Reading UDT values using JDBC" New topic
Author

Reading UDT values using JDBC

Anirban dutta
Ranch Hand

Joined: Aug 08, 2002
Posts: 89
Hi all,
I am accessing a Database column of ORACLE which contains a user-defined type(object) of Oracle. The type contains a NUMBER and a VARCHAR2 field. I have used the "getObject" method of the ResultSet to get the column in a STRUCT object. From this I am able to get the value of the NUMBER field, but I couldn't get the value of the VARCHAR2 field properly. Can anybody pls tell me how to do it. I am using Oracle8i driver version 1.1.
The code:

Thanks and Regards
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Reading UDT values using JDBC