This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes passing a array of values froms oralce Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "passing a array of values froms oralce" Watch "passing a array of values froms oralce" New topic
Author

passing a array of values froms oralce

snebe snebe
Greenhorn

Joined: Aug 12, 2001
Posts: 1
How do i get back array of values from oracle stored procedure?
For eg;I want five columns from a table and it has many rows i need to put it into the array and pass it back to jdbc call.How do i do it?
Thanks,.
--snebe
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

why not return the resultset itself(or ref cursor in oracle?)
example:

taken from: http://developer.novell.com/ndk/doc/samplecode/jdbc_sample/oci7/RefCursorExample.java.html

hope this was helpful,
Jamie
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: passing a array of values froms oralce
 
It's not a secret anymore!