存储过程经验积累1:建包，建存储过程

create or replace package PKG_LIFE_VUL_TRANSACTION_PLUS is

-- Author :
-- Created :
-- Purpose :

--DISTRI_TYPE 基金费用类型
DISTRI_TYPE__FUND_BUY_CHARGE CONSTANT VARCHAR2(3) := '34';

PROCEDURE p_collect_d34(i_trans_id IN t_contract_invest_trans.trans_id%TYPE,
i_bat_change_id IN t_policy_change.change_id%TYPE,
i_batch_date IN DATE,
i_emp_id t_employee.emp_id%TYPE);


end PKG_LIFE_VUL_TRANSACTION_PLUS;
/
create or replace package body PKG_LIFE_VUL_TRANSACTION_PLUS is

PROCEDURE p_collect_d34(i_trans_id IN t_contract_invest_trans.trans_id%TYPE,
i_bat_change_id IN t_policy_change.change_id%TYPE,
i_batch_date IN DATE,
i_emp_id t_employee.emp_id%TYPE
) as

m_sum_amount number;

begin
null
end p_collect_d34;
end PKG_LIFE_VUL_TRANSACTION_PLUS;
/