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 @ email@example.com Oh BTW we are using oracle 8.1.7 database and JDBC 2.0 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.
JavaBeginnersFaq "Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Joined: Dec 13, 2001
Thanks, I have updated it, my original post is still there right ? Gurinder
subject: retrieving varray as an oracle object attribute