aspose file tools*
The moose likes JDBC and the fly likes retrieving varray as an oracle object attribute Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "retrieving varray as an oracle object attribute" Watch "retrieving varray as an oracle object attribute" New topic
Author

retrieving varray as an oracle object attribute

Gurinder Randhawa
Greenhorn

Joined: Dec 13, 2001
Posts: 3
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

Joined: Jul 22, 2000
Posts: 9046
    
  10
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
Gurinder Randhawa
Greenhorn

Joined: Dec 13, 2001
Posts: 3
Thanks, I have updated it, my original post is still there right ?
Gurinder
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: retrieving varray as an oracle object attribute