title: How do I paginate the output of a callable statment/prepared procedure in my JSP?
body: <p>I have this procedure in one of the packages:</p>
  
  <pre><code>PROCEDURE get_namelist
    (
      return_code_out OUT VARCHAR2,
      return_msg_out OUT VARCHAR2,
      id_no_in IN employee.id_no%TYPE,
      name_out OUT employee.name%TYPE,
          addr_out OUT employee.addr%TYPE
    )
    IS
  
    BEGIN
  
      return_code_out := '0000';
      return_msg_out := 'OK';
  
      SELECT i.name, i.addr INTO name_out, addr_out
        FROM employee i
       WHERE i.id_no = id_no_in;
  
  END get_namelist;
  </code></pre>
  
  <p>I am calling this procedure like this in my Java:</p>
  
  <pre><code>DbUtil db = null;
  java.sql.CallableStatement cstmt = null;
  
  
  db = new DbUtil();
  cstmt = db.prepareCall("{ call jack.PACK_EMPLOYEE.get_namelist(?, ?, ?, ?, ?) }");
  
  cstmt.registerOutParameter(1,OracleTypes.VARCHAR);
  cstmt.registerOutParameter(2,OracleTypes.VARCHAR);
  cstmt.setString(3,this.getIdNo());
  cstmt.registerOutParameter(4,OracleTypes.VARCHAR);
  cstmt.registerOutParameter(5,OracleTypes.VARCHAR);
  stmt.execute();
  
  this.setName(cstmt.getString(4));
  this.setAddress(cstmt.getString(5));
  </code></pre>
  
  <p>Currently it's pulling all data from the table. I want to change this, so it will pull a certain number of rows into multiple pages. I looked all over and found out how to do JSP pagination when I am using the SQL query in Java code itself, but I coudn't find any example that shows this using package and callable statement.</p>
  
  <p>How can I modify this code so I can use JSP pagination?</p>