passing a array of values froms oralce

[snebe snebe]

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]

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

// Prepare a PL/SQL call
    CallableStatement call = conn.prepareCall ("{ ? = call java_refcursor.job_listing (?)}");
    // Find out all the SALES person
    call.registerOutParameter (1, OracleTypes.CURSOR);
    call.setString (2, "SALES");
    call.execute ();
    ResultSet rset = (ResultSet)call.getObject (1);
   //...process rset... 

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

hope this was helpful,
Jamie