PRC_S_SYS_LOG(7)

 select T.FLAG_VALUE into oi_flag from LBI_SYS_VDF.t_s_flag t where t.flag_code = 'DEBUG';
        if oi_flag = '1' then
          update LBI_SYS_VDF.t_s_sys_log
             set end_time    = sysdate,
                 row_count   = ii_rowcount
           where task_log = 'performance debug'
             and task_id = oi_task_id
             and log_month = to_char(sysdate,'yyyymm');
        end if;
    --add by l00233963 on 20140710 end
    else
    /**
      * @description program error:update the task status to two and update task end time judged by task id
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#end_time = current time()
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_status = (2)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_log = (is_task_log)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#rowcount = (ii_rowcount)
      */
        update LBI_SYS_VDF.t_s_sys_log
           set end_time    = sysdate,
               task_status = ii_task_status,
               task_log    = substr(iv_task_log, 1, 200),
               task_pos    = substr(iv_task_pos, 1, 200),
               row_count   = ii_rowcount
         where task_log <> 'performance debug'
           and task_id = oi_task_id
           and log_month = to_char(sysdate,'yyyymm');

    /**
      * @description send sms when exception.reserved
      */
    end if;

    commit;