方法一:
-- TABLE 类型的遍历
declare
i integer ;
rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
rec_coverage_new := gums_package_underwriting.get_salary_changed_info('PA01000002608233');
i := rec_coverage_new.first;
loop
exit when i is null;
dbms_output.put_line(i);
i := rec_coverage_new.next(i);
end loop;
end;
方法二:
declare
i integer ;
rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
rec_coverage_new := gums_package_underwriting.get_salary_changed_info('PA01000002608233');
i := 0;
while i<rec_coverage_new.count loop
i :=i+1; --从1开始
dbms_output.put_line(i);
end loop;
end;
方法三:
declare
i integer ;
rec_coverage_new gums_package_underwriting.salary_changed_tab;--table类型
begin
rec_coverage_new := gums_package_underwriting.get_salary_changed_info('PA01000002608233');
i := rec_coverage_new.first ;
while i<= rec_coverage_new.last loop
--从1开始
dbms_output.put_line(i);
--i :=i+1;
i := rec_coverage_new.next(i);
end loop;
end;