oracle 存储过程自治事务(Autonomy transaction)

for example:

PROCEDURE PopulateMsgStatusStart(p_nFeedId     NUMBER,

                                  p_nBatchId    NUMBER,
                                  p_nCategoryId NUMBER,
                                  p_nSessionId NUMBER,
                                  p_sUserName   IN NIFM_MSG.USER_NAME%TYPE) IS
    PRAGMA AUTONOMOUS_TRANSACTION;
    v_nFailedCnt NUMBER;
    v_nAllCnt    NUMBER;
    v_nSuccCnt   NUMBER;
    v_sMsgStatus NIFM_MSG.STATUS%TYPE;
    v_nLogID     NUMBER;
  BEGIN

  ......................

 END PopulateMsgStatusStart;