PRC_S_SYS_LOG(3)

最新推荐文章于 2017-06-29 14:34:40 发布

jenya007

最新推荐文章于 2017-06-29 14:34:40 发布

阅读量316

点赞数

分类专栏： Oracle

本文链接：https://blog.csdn.net/jenya007/article/details/44451661

版权

Oracle 专栏收录该内容

227 篇文章 0 订阅

订阅专栏

values
                  (
                   to_char(sysdate,'yyyymm'),
                   oi_task_id,
                   iv_task_name,
                   iv_table_name,
                   iv_task_sign,
                   sysdate,
                   null,
                   1,
                   'program processing',
                   null,
                   null
                  );
    elsif ii_task_status = 0 then
    /**
      * @description program completed: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(sysdate)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_status = (2)
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#task_log = ('program completed')
      * @field-mapping LBI_SYS_VDF#t_s_sys_log#rowcount = (ii_rowcount)
      * @where-mapping LBI_SYS_VDF#t_s_sys_log#task_id = (oi_task_id)
      */