存储过程6

jar_java

于 2011-02-20 19:02:26 发布

阅读量87

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/jar_java/article/details/83842425

                             V_P_REQ_LINES_TBL,
                                    V_RESULT_FLAG,
                                    V_ERROR_DESCRIPTION);
        EXCEPTION
          WHEN OTHERS THEN
            EXCEPTION_MSG := SQLCODE || ':' || SQLERRM;
            UPDATE INT_ERP_PO_INFO
               SET ADD_DATA1   = V_PROC_STATUS,
                   PROC_STATUS = -3,
                   PROC_DATE   = SYSDATE,
                   PROC_REMARK = SUBSTR(EXCEPTION_MSG, 1, 512)
             WHERE REFERENCE_NUM = V_REFERENCE_NUM;

            COMMIT;
            --add by yinlei next the second fetch data
            IS_EXCEPTION_CODE := -1;
            GOTO TO_NEXT;
        END;