procedure_yhs_20160116

create or replace procedure YHS_2015_TJ isbegin  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;