procedure_yhs_20160116

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;