fetch Cur_result into XXX; while Cur_result%found loop ...... ...... ......... fetch Cur_result into XXX; end loop;
补充楼上的: 试一下 ...... as tabName varchar2(50) :=TableName; type resultTab is table of tabName%rowtype index by binary_integer; v_resultTab resultTab;fetch Cur_result into v_resultTab(1); while Cur_result%found loop dbms_output.putline(v_resultTab(1).field1); ...... ......... fetch Cur_result into v_ResultTab(1); end loop;
fetch Cur_result into XXX;
while Cur_result%found loop
......
......
.........
fetch Cur_result into XXX;
end loop;
试一下
......
as
tabName varchar2(50) :=TableName;
type resultTab is table of tabName%rowtype index by binary_integer;
v_resultTab resultTab;fetch Cur_result into v_resultTab(1);
while Cur_result%found loop
dbms_output.putline(v_resultTab(1).field1);
......
.........
fetch Cur_result into v_ResultTab(1);
end loop;