private void getMaxCityPop(Connection myConnect, String Department) throws SQLException {
        CallableStatement cStmt = myConnect.prepareCall("{CALL UNBOUND_DEMO(?)}");
        cStmt.setString(1, Department);
        cStmt.execute(  );
        ResultSet rs1 = cStmt.getResultSet(  );
        while (rs1.next(  )) {
             System.out.println(rs1.getString("Name") + “ ” + rs1.getString("Population"));
         }
         rs1.close(  );
         /* process second result set */
         if (cStmt.getMoreResults(  )) {
              ResultSet rs2 = cStmt.getResultSet(  );
              while (rs2.next(  )) {
                   System.out.println(rs2.getString("Name") + " " + rs2.getString("Population")
                     
             }
             rs2.close(  );
         }
         cStmt.close(  );
     }


Latest conferences

We have 39 guests and no members online

oracle_ace