This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 9043
    
  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
 
Similar Threads
Sending java List to oracle DataBase
help with how to call from JPA oracle stored procedure with array as IN parameter
Mapping Varray of Object Type in oracle through jdbc
Connecting Websphere 5.0 to Oracle 8.1.7
Can i use arryas with storedprocedures?if yes give me example.