declare
    type t_myCol is table of dept%rowtype;
    v_tbl t_myCol;
    v_cnt number;
begin
    v_tbl(1).deptno := 10;
    v_tbl(1).dname := 'NEW YORK';
    v_tbl(1).loc := 'ACCOUNTING';
    select  count(*)
      into  v_cnt
      from  table(v_tbl);
end;
/
      from  table(v_tbl);
                  *
ERROR at line 11:
ORA-06550: line 11, column 19:
PLS-00642: local collection types not allowed in SQL statements
ORA-06550: line 11, column 13:
PL/SQL: ORA-22905: cannot access rows from a non-nested table item
ORA-06550: line 9, column 5:
PL/SQL: SQL Statement ignored


SQL>

create or replace
  package pkg1
    is
      type t_myCol is table of dept%rowtype;
end;
/
declare
    v_tbl pkg1.t_myCol := pkg1.t_myCol();
    v_cnt number;
begin
    v_tbl.extend;
    v_tbl(1).deptno := 10;
    v_tbl(1).dname := 'NEW YORK';
    v_tbl(1).loc := 'ACCOUNTING';
    select  count(*)
      into  v_cnt
      from  table(v_tbl);
end;
/

PL/SQL procedure successfully completed.

SQL>

create or replace
  package pkg1
    is
      type t_myCol is table of dept%rowtype index by binary_integer;
end;
/
declare
    v_tbl pkg1.t_myCol; -- := pkg1.t_myCol();
    v_cnt number;
begin
--    v_tbl.extend;
    v_tbl(1).deptno := 10;
    v_tbl(1).dname := 'NEW YORK';
    v_tbl(1).loc := 'ACCOUNTING';
    select  count(*)
      into  v_cnt
      from  table(v_tbl);
end;
/

PL/SQL procedure successfully completed.

SQL>