calling oracle stored procedure from java

String query = "begin ? := sp_get_stocks(?); end;";
CallableStatement stmt = conn.prepareCall(query);// register the type of the out param - an Oracle specific type

stmt.registerOutParameter(1, OracleTypes.CURSOR);// set the in param
stmt.setFloat(2, price);// execute and retrieve the result
setstmt.execute();
ResultSet rs = (ResultSet)stmt.getObject(1);// print the results
while (rs.next()) {
System.out.println(
rs.getString(1) + "\t" + rs.getFloat(2) + "\t" + rs.getDate(3).toString()
);
}

Hiç yorum yok: