declare
--类型定义
cursor c_job
is
select id,wgbm
from mdxiugai;
--定义一个游标变量v_cinfo c_emp%ROWTYPE ,该类型为游标c_emp中的一行数据类型
c_row c_job % rowtype;
begin
for c_row in c_job loop
update md_mdsjxx set orgcode=c_row.wgbm where id=c_row.id;
update md_cljl set orgcode=c_row.wgbm where mdid=c_row.id;
end loop;
commit;
exception
when others then
rollback;
end;