oracle定义了,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; }