create or replace procedure YHS_2015_TJ is
begin
declare
cursor c_xh is
select * from nsr_ls;
v_nsr c_xh%rowtype;
begin
delete aoqiang_1.nsr_yhs;
commit;
open c_xh;
loop
fetch c_xh
into v_nsr;
exit when c_xh%NOTFOUND;
-- dbms_output.put_line(v_nsr.xh);--buffer overflow
insert into nsr_yhs
(uuid, xh, value1, vluae2, lrrq, lrr_dm, xgrq, xgr_dm)
values
(sys_guid(),
v_nsr.xh,
v_nsr.nsrmc,
'b',
sysdate,
'10086b',
null,
null);
commit;
end loop;
close c_xh;
end;
end YHS_2015_TJ;
procedure_yhs_20160116
最新推荐文章于 2019-08-01 13:36:42 发布