java调用存储过程

先创建一个存储过程
create or replace function addvalue(value1 in number, value2 in number) return number is
result number;
begin
result:=value1+value2;
return(result);
end ;
下面是java调用
Connection conn = JDBCUtils.getConnection();
CallableStatement cs = conn.prepareCall("{? = call addvalue(?, ?)}");
// register input parameters
cs.setInt(2, 2);
cs.setInt(3, 3);
// regsiter ouput parameters
cs.registerOutParameter(1, Types.INTEGER);
cs.execute();
int outParam = cs.getInt(1);
System.out.println(outParam);