begin
/**
* @description initialize variable
* @field-mapping vd_begin_date = (sysdate)
* @field-mapping vv_procedure_name = ('sp_dw_tab_add_partition')
* @field-mapping vd_deal_date = ( to_date(iv_char_date,'yyyymmdd') )
* @field-mapping vv_table_name = ('tb_sys_tab_partitions')
*/
select sysdate into vd_begin_date from dual; --get start time
vv_procedure_name := 'sp_dw_tab_add_partition';
vd_deal_date := to_date(iv_char_date,'yyyymmdd');
vv_table_name := 'tb_sys_tab_partitions';
on_statuscode := 0;
/**
* @description program begin logging in
* @field-mapping vi_log_status = ('1')
* @call sp_dw_sys_log
*/
vi_log_status := 1;
vi_log_status := 0;
/** @description update process flag to 0*/
update tb_sys_tab_partitions
set proc_flag_id='0';
/** @description deal with daily partition*/
declare
/**
* @description initialize variable
* @field-mapping vd_begin_date = (sysdate)
* @field-mapping vv_procedure_name = ('sp_dw_tab_add_partition')
* @field-mapping vd_deal_date = ( to_date(iv_char_date,'yyyymmdd') )
* @field-mapping vv_table_name = ('tb_sys_tab_partitions')
*/
select sysdate into vd_begin_date from dual; --get start time
vv_procedure_name := 'sp_dw_tab_add_partition';
vd_deal_date := to_date(iv_char_date,'yyyymmdd');
vv_table_name := 'tb_sys_tab_partitions';
on_statuscode := 0;
/**
* @description program begin logging in
* @field-mapping vi_log_status = ('1')
* @call sp_dw_sys_log
*/
vi_log_status := 1;
vi_log_status := 0;
/** @description update process flag to 0*/
update tb_sys_tab_partitions
set proc_flag_id='0';
/** @description deal with daily partition*/
declare
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-1061428/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
