oracle过程的定义与使用

1）pl/sql developer中执行过程：

begin
set_sequence_cert_paper_print(64);
end;

 

2）java中调用过程：

 

public String getCertPaperPrintNo(){
  String stSql = "select seq_cert_paper_print.nextval as paperNo from dual";
  Connection con = null;
  String stCertPaperPrintNo = "";
  try{
   con = DB.getConnection();
   Statement stmt = con.createStatement();
   ResultSet rs = stmt.executeQuery(stSql);
   ResultSet rs2 = null;
   while(rs.next()){
    stCertPaperPrintNo = rs.getString("paperNo");
    Integer iStart = Integer.valueOf(stCertPaperPrintNo) - 1;
    CallableStatement csmt = con.prepareCall("call set_sequence_cert_paper_print(" + String.valueOf(iStart) + ")");
    csmt.execute();
    rs2 = stmt.executeQuery("select seq_cert_paper_print.currval as paperNo from dual");
    while(rs2.next()){
     stCertPaperPrintNo = rs2.getString("paperNo");
    }
   }
  }catch(Exception e){
   e.printStackTrace();
  }finally{
   DB.closeConnection(con);
  }   
  return stCertPaperPrintNo;
 }