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
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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: 9033
    
  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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: retrieving varray as an oracle object attribute
 
Similar Threads
Connecting Websphere 5.0 to Oracle 8.1.7
Can i use arryas with storedprocedures?if yes give me example.
help with how to call from JPA oracle stored procedure with array as IN parameter
Mapping Varray of Object Type in oracle through jdbc
Sending java List to oracle DataBase