procedure role_module_list is
type record_type is record(v1 number(9));
type t_table is table of record_type INDEX BY BINARY_INTEGER;
t1 t_table;
begin
t1(1).v1 := 0;
select v1 from table(t1);--无法从非索引表项访问行 请问错在哪儿.应该怎么写
end role_module_list;
type record_type is record(v1 number(9));
type t_table is table of record_type INDEX BY BINARY_INTEGER;
t1 t_table;
begin
t1(1).v1 := 0;
select v1 from table(t1);--无法从非索引表项访问行 请问错在哪儿.应该怎么写
end role_module_list;
type record_type is record(v1 number(9));
type t_table is table of record_type INDEX BY BINARY_INTEGER;
t1 t_table;
CURSOR c1 is select * from table where rownum<10;
i integer;
begin
open c1;
loop
i:=1;
fetch c1 into t1(i);
if(c1%notfound) then
exit;
end if;
if(t1.exists(1)) then
dbms_output.put_line(t1(i).v1);
i:=i+1;
end if;
end loop; end role_module_list;
不过算了 还是结分吧.