CREATE TYPE names_t IS TABLE OF VARCHAR2 (100) 

DECLARE 
   CURSOR cur_fetch_records (v_shop_names names_t) 
   IS 
      SELECT last_name 
        FROM hr.employees 
       WHERE last_name IN (SELECT * FROM TABLE (v_shop_names)); 
 
   l_names   names_t := names_t ('King', 'Ande', 'Bell'); 
   l_name    hr.employees.last_name%TYPE; 
BEGIN 
   OPEN cur_fetch_records (l_names); 
 
   FETCH cur_fetch_records INTO l_name; 
 
   DBMS_OUTPUT.put_line (l_name); 
 
   CLOSE cur_fetch_records; 
END;