• 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: 9079
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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!