Oracle 索引-by表/关联数组

SQL> create or replace
  2  package pkg is
  3    type t is table of number index by pls_integer;
  4    procedure p;
  5  end;
  6  /

Package created.

SQL>
SQL> create or replace
  2  package body pkg is
  3
  4  procedure p is
  5    r t;
  6  begin
  7    r(1) := 10;
  8    r(2) := 20;
  9
 10    for i in ( select * from table(r)
 11              )
 12    loop
 13      null;
 14    end loop;
 15  end;
 16
 17  end;
 18  /

Warning: Package Body created with compilation errors.

SQL>
SQL>
SQL> sho err
Errors for PACKAGE BODY PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
9/14     PL/SQL: SQL Statement ignored
9/28     PL/SQL: ORA-22905: cannot access rows from a non-nested table
         item

9/34     PLS-00382: expression is of wrong type

SQL> create or replace
  2  package pkg is
  3    type t is table of number index by pls_integer;
  4    procedure p;
  5  end;
  6  /

Package created.

SQL>
SQL> create or replace
  2  package body pkg is
  3
  4  procedure p is
  5    r t;
  6  begin
  7    r(1) := 10;
  8    r(2) := 20;
  9
 10    for i in ( select * from table(r)
 11              )
 12    loop
 13      null;
 14    end loop;
 15  end;
 16
 17  end;
 18  /

Package body created.