oracle sql%rowcount 统计DML操作影响的行数

声明：

v_rijie_count_shiji number(12);   
v_jfjl_count_shiji number(12);    
v_fyjl_count_shiji number(12);  

 

初始化：

v_rijie_count_shiji := 0;
v_jfjl_count_shiji := 0;
v_fyjl_count_shiji := 0;

统计：

DELETE FROM feiyong_jilu_ys ys WHERE ys.jfjl_id = rec_jiaofei_jilu.jfjl_id;                        
v_fyjl_count_shiji := v_fyjl_count_shiji + sql%rowcount; 
说明：sql%rowcount表示成功 DELETE 的记录数目

UPDATE jiaofei_jilu SET Jfjl_jiezhuan_bz  '1'
WHERE jfjl_id = rec_jiaofei_jilu.jfjl_id;

v_jfjl_count_shiji := v_jfjl_count_shiji + sql%rowcount; 
说明：sql%rowcount表示成功 UPDATE 的记录数目