1 public Row[] getEmployees(List empIds) { 2 ViewObjectImpl empVO = this.getEmpVO(); 3 String inClause = getInClause(empIds); 4 //setting the where cluase to use the generated in clause 5 empVO.setWhereClause("EmpEO.EMPNO in (" + inClause + ")"); 6 //clearing all existing where clause params if any 7 empVO.setWhereClauseParams(null); 8 //setting values for all bind variables one by one in the in clause 9 for (int i = 0; i < empIds.size(); i++) { 10 //setting the value for each positional bind variable 11 empVO.setWhereClauseParam(i, empIds.get(i)); 12 } 13 empVO.setRangeSize(-1); 14 //executing the query 15 empVO.executeQuery(); 16 //returning the resultant rows 17 return empVO.getAllRowsInRange(); 18 }