create or replace procedure pro_order_info_update as
begin
declare
v_line_num varchar2(10);
begin
v_line_num:='[1-1-1]';
update svc_order_info_bak t set t.rec_dept=123 where t.order_id='425';
v_line_num:='[1-1-2]';
update svc_order_info_bak t set t.AMOUNT='sdf' where t.order_id='425';
--v_line_num:='[1-1-3]';
-- code 3;
--v_line_num:='[1-1-4]';
-- code 4;
commit;
exception when others then
rollback;
dbms_output.put_line('error on:'||v_line_num||', message:'||SQLCODE||','||sqlerrm);
end;
end pro_order_info_update;