如果要写一个临时的语句块调用某个过程,可以参照以下方式:
declare cursor v_is is select distinct aac001 from sic84 where aab001=511500000999 ; pi_data lew_pub.data; po_fhz varchar2(1000); po_msg varchar2(2000); begin for x in v_is loop --select x.aac001 into PI_DATA.AAC001 from dual; --select ‘110‘ into PI_DATA.AAE140 from dual ; PI_DATA.AAC001 := x.aac001; PI_DATA.AAE140 := ‘110‘; lew_pub.repair_ac20_by_sj(pi_data, po_fhz, po_msg); if po_fhz <> ‘1‘ then dbms_output.put_line(‘出错了:‘||po_msg); end if; end loop; end;
原文:http://www.cnblogs.com/Sunnor/p/4875140.html