Fetch and return as array

[cleanair4me]

I am trying to retrieve the results from a query of my Oracle 9i database. In every call it should retrieve a single row from the results and returns it as an array, where each field of the row is in an array key.



My attempt but it doesnt give me any data:

while (rs.next())
{
String res = stmt.executeQuery("select * from Customers where ID = 34"); 

String firstname = "";
String lastname = "";
String $inf []; 
if($inf.equals(getParameterValues($res)) { 
   out.write(inf[firstname]);
   out.write(inf[lastname]);
}

 

[prosper]

http://www.angelfire.com/home/jasonvogel/java_jdbc_arrays.html

Please focus on this:

callableStatement.registerOutParameter(3,OracleTypes.ARRAY,"TYPE_STRING_ARRAY");

and related program code.
You could see the way to get the array from the code in the hyperlink.
There are only a few tutorials on the web for this topics.

Connection conn = ...
OracleCallableStatement cs = (OracleCallableStatement)conn.prepareCall ( "{...