*
The moose likes JDBC and the fly likes Mapping Varray of Object Type in oracle through jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Mapping Varray of Object Type in oracle through jdbc" Watch "Mapping Varray of Object Type in oracle through jdbc" New topic
Author

Mapping Varray of Object Type in oracle through jdbc

Arul Prasad
Ranch Hand

Joined: Jan 20, 2005
Posts: 57
hi

I have a query regarding to map the varray of object type in oracle through JDBC.

I need to initiate java array object and initialise into oracle varray how to do that .?

For ex

I have a Object type called USER_TRANS , and array USER_TRANS_DETAIL



I am having a procedure with input param as USER_TRANS_DETAIL type

So to call the procedure from jdbc i need to populate the varray in java how to do that. I can use custom java Class for mapping the type in oracle but it was used only for reading . Is anyother way to initiate it from jdbc ..?


With Regards<br />Arul
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mapping Varray of Object Type in oracle through jdbc
 
Similar Threads
Can i use arryas with storedprocedures?if yes give me example.
retrieving varray as an oracle object attribute
Sending java List to oracle DataBase
help with how to call from JPA oracle stored procedure with array as IN parameter
Passing String array as out parameter to stored procedure