在OLTP的环境下使用大事务出现的问题 (2)

begin transaction1_2
      insert into messgae(id,col1,col2...) values(#id,#col1,#col2...);
      update test_user set sum_reply = sum_reply + 1 where userid=#v_userid;
end transaction1_2

if transaction1_1 执行成功 then

      begin transaction1_2
            insert into messgae(id,col1,col2...) values(#id,#col1,#col2...);
            update test_user set sum_reply = sum_reply + 1 where userid=#v_userid;
      end transaction
      exception when others then
            print insert SQL into log;
            print update SQL into log;
            将log信息发送报警邮件,此SQL可以手动重新执行,这种情况是比较少见的，但出现了，我们是可以进行数据订正的
            print another way  
            if you don't want to execute insert SQL,update SQL,you can execute the SQL mannul as follows:
               update thread set post_count=nvl(post_count,0) - 1 where id=#v_id;
            end if;
            注：恢复数据一致性的方法有两种，根据实际情况恰当选择    
end if;