Oracle call store procedure

最新推荐文章于 2023-05-26 21:18:06 发布

weixin_34403693

最新推荐文章于 2023-05-26 21:18:06 发布

阅读量142

点赞数

文章标签：数据库

原文链接：https://my.oschina.net/l1z2g9/blog/124563

版权

为什么80%的码农都做不了架构师？>>>

variable cur refcursor;
execute GET_APP_POOL_CURSOR(:cur, 'SCREEN', 'N');
print :cur

sf.getCurrentSession().doWork(new Work() {
 @Override
 public void execute(Connection conn) throws SQLException {
  final CallableStatement cs = conn.prepareCall("{call GET_APP_POOL_CURSOR(?, ?, ?)}");
  cs.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
  cs.setString(2, "aa");
  cs.setString(3, "bb");

  cs.execute();
  final ResultSet rs = (ResultSet) cs.getObject(1);
  while (rs.next()) {
    final EvaluationAnpAppVW evaluationAnpAppVW = new EvaluationAnpAppVW();
    evaluationAnpAppVW.setAnpPrdSeq(rs.getLong(2));
  }
 }
}

转载于:https://my.oschina.net/l1z2g9/blog/124563