Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table t (id, memo, created) as
    select rownum, 'memo '||lpad (rownum, 4, '0'), sysdate
    from dual connect by level<=3
3 rows affected

create or replace package pack as
    type rec is record (id int, memo varchar2 (96), created date default sysdate);
    type arrbynum is table of t%rowtype index by pls_integer;
    type arrbykey is table of t%rowtype index by varchar2 (32);
end;
/
declare k pack.arrbykey;
begin
    select * bulk collect into k from t;
end;
/
ORA-06550: line 3, column 32:
PLS-00657: Implementation restriction: bulk SQL with associative arrays with VARCHAR2 key is not supported.
ORA-06550: line 3, column 34:
PL/SQL: ORA-00904: : invalid identifier
ORA-06550: line 3, column 5:
PL/SQL: SQL Statement ignored

declare
    n pack.arrbynum;
    rc sys_refcursor;
    rec t%rowtype;
begin
    --#1
    select * bulk collect into n from t;
    --#2
    open rc for select * from t;
    loop fetch rc into rec;
        exit when rc%notfound;
        n(rc%rowcount) := rec; 
    end loop;
end;
/
1 rows affected

declare 
    k pack.arrbykey;
    key char (8);
begin
    for r in (select * from t) loop
        key := 'code'||lpad (r.id, 4, '0');
        k (key) := r;
    end loop;
end;
/
1 rows affected