CREATE OR REPLACE PROCEDURE createtypeinfo(cslx IN VARCHAR2, csz IN VARCHAR2, fid IN NUMBER )
IS
tempflid number;--声明临时变量BEGIN
declare
type v_ar is varray(100) of number;--声明数组 长度为100
my_ar v_ar := v_ar(20661,20774,20563,25114,25478,23514);--赋值数组为固定数值
begin
for i in 1 .. my_ar.count loop
dbms_output.put_line(my_ar(i));--循环里具体的操作
end loop;
commit;
end;
END createtypeinfo;