ORACLE 陣列在過程中的應用

ORACLE 陣列在儲存過程中的應用,現在舉例項如下:

首先要初始化陣列變數,然後對其分配儲存數量.......

[@more@]

create or replace procedure research(username in varchar2)
as
TYPE num_t_name is varray(100) of varchar2(30) ;
a num_t_name;
c varchar2(10);
j number;
cursor mycur is
select table_name from all_tab_columns where owner=username ;
begin
a := num_t_name();
a.extend(2);
j := 1;
for cur in mycur loop
c := to_char(j,'0000');
--dbms_output.put_line(c);
a(j) := cur.table_name;
insert into T_TABLEPREPARE1(tid,tname)
values(c,a(j));
j := j + 1;
end loop;
commit;
end;