aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Reading UDT values using JDBC