GeeCON Prague 2014*
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
 
GeeCON Prague 2014
 
subject: passing a array of values froms oralce