PRC_S_SYS_LOG(3)

来源:互联网 发布:无间道傻强是警察知乎 编辑:程序博客网 时间:2024/06/05 07:53
  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)
      */
0 0
原创粉丝点击