By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TYPE s_arr IS TABLE OF VARCHAR2(255);
CREATE TYPE d_arr IS TABLE OF s_arr;
DECLARE
cities d_arr;
cities_cur sys_refcursor;
city VARCHAR2(255);
BEGIN
cities := d_arr(
s_arr('Vienna', 'Graz'),
s_arr('Milan', 'Turin')
);
OPEN cities_cur FOR
SELECT cta.COLUMN_VALUE
FROM TABLE(cities) ctd,
TABLE(ctd.COLUMN_VALUE) cta;
LOOP
FETCH cities_cur INTO city;
EXIT WHEN cities_cur%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(city);
END LOOP;
END;
/
1 rows affected
dbms_output:
Vienna
Graz
Milan
Turin