Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE
  TYPE recordType is RECORD ( a NUMBER, b VARCHAR2(20) );
  TYPE recordTable is TABLE of recordType;
  
  v_recs recordTable;
BEGIN
  v_recs.EXTEND(2);
  v_recs(1).a := 23;
  v_recs(1).b := 'ABC';
  v_recs(2).a := 42;
  v_recs(2).b := 'DEF';
  
  FOR i IN (SELECT * FROM TABLE(v_recs))
  LOOP
    DBMS_OUTPUT.PUT_LINE(i.a || ', ' || i.b);
  END LOOP;
END;
/
ORA-06550: line 13, column 33:
PLS-00642: local collection types not allowed in SQL statements
ORA-06550: line 13, column 27:
PL/SQL: ORA-22905: cannot access rows from a non-nested table item
ORA-06550: line 13, column 13:
PL/SQL: SQL Statement ignored
ORA-06550: line 15, column 26:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 15, column 5:
PL/SQL: Statement ignored

CREATE TYPE objectType is OBJECT( a NUMBER, b VARCHAR2(20) );
CREATE TYPE objectTable is TABLE of objectType;
DECLARE
  v_objs objectTable := objectTable();
BEGIN
  v_objs.EXTEND(2);
  v_objs(1) := objectType(23, 'ABC');
  v_objs(2) := objectType(42, 'DEF');

  FOR i IN (SELECT * FROM TABLE(v_objs))
  LOOP
    DBMS_OUTPUT.PUT_LINE(i.a || ', ' || i.b);
  END LOOP;
END;
/
1 rows affected

dbms_output:
23, ABC
42, DEF

DECLARE
  v_objs objectTable := objectTable();
BEGIN
  v_objs.EXTEND(2);
  v_objs(1) := objectType(23, 'ABC');
  v_objs(2) := objectType(42, 'DEF');

  FOR i IN (SELECT * FROM v_objs)
  LOOP
    DBMS_OUTPUT.PUT_LINE(i.a || ', ' || i.b);
  END LOOP;
END;
/
ORA-06550: line 8, column 27:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 8, column 13:
PL/SQL: SQL Statement ignored
ORA-06550: line 10, column 26:
PLS-00364: loop index variable 'I' use is invalid
ORA-06550: line 10, column 5:
PL/SQL: Statement ignored

CREATE TABLE table_name (id, value) AS
SELECT 23, 'UVW' FROM DUAL UNION ALL
SELECT 42, 'XYZ' FROM DUAL;
2 rows affected

DECLARE
  v_objs objectTable := objectTable();
BEGIN
  v_objs.EXTEND(2);
  v_objs(1) := objectType(23, 'ABC');
  v_objs(2) := objectType(42, 'DEF');

  FOR i IN (SELECT o.a, o.b, t.value
            FROM   TABLE(v_objs) o
                   INNER JOIN table_name t
                   ON o.a = t.id)
  LOOP
    DBMS_OUTPUT.PUT_LINE(i.a || ', ' || i.b || ', ' || i.value);
  END LOOP;
END;
/
1 rows affected

dbms_output:
23, ABC, UVW
42, DEF, XYZ