Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

retrieving varray as an oracle object attribute

 
Gurinder Randhawa
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a question regarding JDBC and oracle objects. I have an Oracle object "PolicyObj" in my oracle database which has a varray of customer objects.
How do i retrieve the varray as an attribute from my PolicyObj, I am using the oracle.sql.STRUCT approach...I have successfully retrieved all the other attributes, but i don't know how to get the array of objects attribute....
if anyone can help that would be great. Please feel free to email me @ randhawag@hotmail.com
Oh BTW we are using oracle 8.1.7 database and JDBC 2.0
Gurinder
 
Marilyn de Queiroz
Sheriff
Posts: 9059
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Gurinder,

Your name, randhawag, doesn't agree with the javaranch guidelines. Please take a moment and re-register after reviewing the guidelines at http://www.javaranch.com/name.jsp. We would like you to be able to continue to post here at JavaRanch.
 
Gurinder Randhawa
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, I have updated it, my original post is still there right ?
Gurinder
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic