declare
  type ta_v  is table of varchar2(10);
name varchar2(10);
  var_ta  table_varchar;
begin
  var_ta  := ta_v('SMITH', 'ANIL', 'JONES', 'FORD');

  for i in 1 .. var_ta.count loop
Begin
select ename into name from emp where ename in var_ta(i);
dbms_output.put_line(name);
exception
when others then
dbms_output.put_line('Skipped values'|| ': ' || var_ta(i));
var_ta(i):=var_ta.next(i);
end;
end loop;
end;
/

var_ta  table_varchar;

SQL> set serveroutput on;
SQL> 
SQL> DECLARE
  2     TYPE TA_V IS TABLE OF VARCHAR2(10);
  3     NAME   VARCHAR2(10);
  4     VAR_TA TA_V;
  5  BEGIN
  6     --VAR_TA := TA_V('SMITH', 'ANIL', 'JONES', 'FORD');
  7     FOR I IN (SELECT ENAME FROM EMP) LOOP
  8        VAR_TA := TA_V(I.ENAME);
  9  
 10        FOR I IN 1 .. VAR_TA.COUNT LOOP
 11           BEGIN
 12              SELECT ENAME INTO NAME FROM EMP WHERE ENAME IN VAR_TA(I);
 13              DBMS_OUTPUT.PUT_LINE(NAME);
 14           EXCEPTION
 15              WHEN OTHERS THEN
 16                 DBMS_OUTPUT.PUT_LINE('Skipped values' || ': ' || VAR_TA(I));
 17                 VAR_TA(I) := VAR_TA.NEXT(I);
 18           END;
 19        END LOOP;
 20     END LOOP;
 21  END;
 22  /
 
KING
BLAKE
CLARK
JONES
SCOTT
FORD
SMITH
ALLEN
WARD
MARTIN
TURNER
ADAMS
JAMES
MILLER
 
PL/SQL procedure successfully completed