1 PACKAGE AST_MVIEW_REFRESH_CUHK AUTHID CURRENT_USER AS
2 /* $Header: astchmvs.pls 115.1 2002/12/04 21:49:12 qliu ship $ */
3
4
5 /*============================================================================
6 This package is created for user to resolve the fine grain access policy
7 conflicts with materialized view (ORA-30372).
8
9 In order for the materialized view to work correctly, any fine grain
10 access control procedure in effect for the query must return a null policy
11 when the materialized view is being created or refreshed.
12 ============================================================================*/
13
14
15 PROCEDURE MView_Refresh_Pre(
16 p_mview_name IN VARCHAR2,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21
22 PROCEDURE MView_Refresh_Post(
23 p_mview_name IN VARCHAR2,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_data OUT NOCOPY VARCHAR2
26 );
27
28 END AST_MVIEW_REFRESH_CUHK;
29
[Home] [Help]