oracle刷新存储过程,Oracle 存储过程刷新物化视图

CREATE OR REPLACE PACKAGE BODY REFRESH_MVIEW IS

-- Author : 241433

-- Created : 12/2/2010 4:25:04 PM

-- Purpose : This PKG is for REFRESH MVIEW

-- Public type declarations

CONS_BCR_LIST VARCHAR2(40) := 'BCR_UI_BLOCK_LIST_ALL_VW';

CONS_BCR_LIST_QUERY VARCHAR2(40) := 'BCR_UI_BLOCK_LIST_QUERY_VW';

CONS_BCR_RULE VARCHAR2(40) := 'BCR_UI_BLOCK_RULE_ALL_VW';

CONS_CUST_HCP VARCHAR2(40) := 'CAPUBLISH.HCP_CUST_PROFILE_VW';

CONS_CUST_HCA VARCHAR2(40) := 'CAPUBLISH.HCA_CUST_PROFILE_VW';

PROCEDURE REFRESH_MVIEW(P_MVIEW_NAME IN VARCHAR2) IS

BEGIN

DBMS_MVIEW.REFRESH(P_MVIEW_NAME);

END REFRESH_MVIEW;

PROCEDURE REFRESH_MVIEW_BCR_REPORT IS

BEGIN

REFRESH_MVIEW(CONS_BCR_LIST);

REFRESH_MVIEW(CONS_BCR_LIST_QUERY);

REFRESH_MVIEW(CONS_BCR_RULE);

END REFRESH_MVIEW_BCR_REPORT;

PROCEDURE REFRESH_MVIEW_CUST IS

BEGIN

REFRESH_MVIEW(CONS_CUST_HCP);

REFRESH_MVIEW(CONS_CUST_HCA);

END REFRESH_MVIEW_CUST;

END REFRESH_MVIEW;