Java调用有返回值的存储过程
一共五个参数;参数1,2,3,4,均为 输入的参数;参数5为输出的参数
CallableStatement proc = conn.prepareCall("{call pack_his.proc_history(?,?,?,?,?)}");
proc .setString(1, orignal_tableName);
proc .setString(2, history_tableName);
proc .setInt(3, year);
proc.setString(4, "D");
proc.registerOutParameter(5, Types.VARCHAR);
proc.execute();
String rs_temp = null;
rs_temp = proc.getString(5);