Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reading UDT values using JDBC

 
Anirban dutta
Ranch Hand
Posts: 89
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic