ORA-01403: 未找到数据问题+存储过程循环跳转

    执行一个ＰＬ／ＳＱＬ 块，总是报这个错：ORA-01403: 未找到数据问题，在网上搜索了半天，找到一个解决办法。

比较彻底的办法就是添加一个异常处理~

    另外，在其中还应用了存储循环跳转应用,很好地复习了存储过程开发！解决问题方法如下：

DECLARE
  vn_sum_old NUMBER(10);
  vn_sum_new NUMBER(10);
  vn_count NUMBER(10) := 0;

  cursor get_tcf is
  SELECT account_id AS acct_id,user_idnew AS user_id,perserve01 AS acct_item_type_id from table_a  
  where city_code='921'
  and fee_date='201107'
  and table_source = 0
  and perserve03 is null
  and disct_rule_id=211100278;
 
BEGIN
     for cur in get_tcf LOOP
        SELECT SUM(charge) INTO vn_sum_old
        FROM table_d
        WHERE acct_item_type_id =  cur.acct_item_type_id
        AND acct_id = cur.acct_id
        GROUP BY acct_id;
       
        BEGIN               --这是针对性异常处理的应用
            SELECT NVL(SUM(fee),0) INTO vn_sum_new
            FROM ucr_dtb1.table_c
            WHERE
              detail_item_code IN(
                SELECT new_item_code FROM table_b@to_accttst
                WHERE acct_item_type_id IN cur.acct_item_type_id
              )
            AND acct_id = cur.acct_id
            GROUP BY acct_id ;
        EXCEPTION
        WHEN no_data_found THEN
        --NULL;
        GOTO point1;  --这是循环跳转应用
        END;

        IF vn_sum_old = vn_sum_new THEN
           UPDATE table_a SET perserve03 = '............'
           WHERE
           perserve01 = cur.acct_item_type_id
           AND user_idnew = cur.user_id;
        END IF;
     
        IF vn_count = 100 THEN
           COMMIT;
           vn_count := 0;
        END IF;
        vn_count := vn_count+1;
       
        <<point1>>   --这是断点设置
        NULL;
       
     end loop;
    
     DBMS_OUTPUT.PUT_LINE(vn_count);

END ;