Hello All,
In Oracle 19c, I want to use associative array in sql but it gives error.
SQL> create package pkg_test
2 is
3 type str_type is table of integer index by varchar2(1000);
4 arr_str str_type;
5 end;
6 /
Package created
SQL>
SQL> begin
2
3 pkg_test.arr_str('test 1') := 1;
4 pkg_test.arr_str('test 2') := 2;
5
6 end;
7 /
PL/SQL procedure successfully completed
SQL> select * from table(pkg_test.arr_str);
select * from table(pkg_test.arr_str)
ORA-06553: PLS-221: 'ARR_STR' is not a procedure or is undefined
Thanks in advance