declare    type number_index_by_string is table of number index by varchar2(30);    type string_index_by_number is table of dept.loc%type index by pls_integer;      v_country_codes  number_index_by_string;    v_countries      string_index_by_number;…