File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
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
 
wood burning stoves
 
subject: passing a array of values froms oralce