create or replace procedure aaaa as p_fund_begin number; cursor cur_aff is select A.cause_code,A.unit_code from aff_adjust A where A.cause_code='12'; --rs1 cur_aff%rowtype; cursor cur_period(p_no varchar2) is select period_no from epd_period where code=p_no; --rs2 cur_period%rowtype; p_cause_no varchar2(10); begin for v_aff in cur_aff loop for v_period in cur_period(v_aff.cause_code) loop dbms_output.put_line(v_period.period_no); end loop; end loop; end aaaa; /
as
p_fund_begin number;
cursor cur_aff is
select A.cause_code,A.unit_code from aff_adjust A where A.cause_code='12';
--rs1 cur_aff%rowtype;
cursor cur_period(p_no varchar2) is
select period_no from epd_period
where code=p_no;
--rs2 cur_period%rowtype;
p_cause_no varchar2(10);
begin
for v_aff in cur_aff loop
for v_period in cur_period(v_aff.cause_code) loop
dbms_output.put_line(v_period.period_no);
end loop;
end loop;
end aaaa;
/
是因为“..处理过程”中出现了错误,