缓慢变化思想1

来源：互联网发布：网络教育全国统考难吗编辑：程序博客网时间：2024/05/21 22:58

CREATE OR REPLACE PROCEDURE prc_e_fsi_link(iv_start_date in varchar2,
                                           iv_end_date   in varchar2,
                                           oi_return     out integer)
/** head
* @name LBI_EDM_VDF.prc_e_fsi_link
* @caption
* @type   collected by day
* @parameter iv_time in varchar2   statis date, format:yyyymmddhh24mi
* @parameter oi_return out integer   execute state: 0 means ok ; others means error.
* @target LBI_EDM_VDF#prc_e_fsi_link
* @version 2.0
* @author shuguijun
* @create-date 2014-04-21
* @todo
* @version
* @mender <>
* @modify_date <yyyy-m-d>
* @modify_desc <>
* @copyright huawei
*/

/**
* @description                            variable definition
* @variable-define vi_task_id integer     task log id
* @variable-define vv_task_name    varchar2 task name
* @variable-define vv_table_name varchar2 table name
* @variable-define vv_task_pos varchar2   task position
* @variable-define vi_err_code integer    error code
* @variable-define vv_err_msg varchar2    error message
* @variable-define vi_result integer      manipulated record number
* @variable-define exc_error exception    customized error exception variable in program processing
* @variable-define vd_date date           static date
* @variable-define vi_chk_flag integer    check flag
*/
start_date    date;
end_date      date;
vi_task_id    integer; -- task log id
vv_task_name varchar2(30); -- task name
vv_task_pos   varchar2(200); -- task position
vv_table_name varchar2(30); -- table name
--vt_default_time    timestamp;
vi_err_code integer; -- error code
vv_err_msg varchar2(200); -- error message
vi_result   integer; -- manipulated record number

exc_error exception; -- customized error exception variable in program processing

0 0