Oracle call store procedure

1
2
3
variable cur refcursor;
execute GET_APP_POOL_CURSOR(:cur, 'SCREEN', 'N');
print :cur
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
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));
  }
 }
}