PACKAGE: SYS.DBMS_CHANGE_NOTIFICATION

Source

1 PACKAGE dbms_change_notification AUTHID CURRENT_USER as
2 QOS_RELIABLE CONSTANT BINARY_INTEGER := 1;
3 QOS_DEREG_NFY CONSTANT BINARY_INTEGER := 2;
4 QOS_ROWIDS CONSTANT BINARY_INTEGER :=4;
5 QOS_QUERY  CONSTANT BINARY_INTEGER := 8;
6 QOS_BEST_EFFORT CONSTANT BINARY_INTEGER := 16;
7 
8 EVENT_NONE CONSTANT BINARY_INTEGER :=0;
9 EVENT_STARTUP CONSTANT BINARY_INTEGER := 1;
10 EVENT_SHUTDOWN CONSTANT BINARY_INTEGER := 2;
11 EVENT_SHUTDOWN_ANY CONSTANT BINARY_INTEGER := 3;
12 EVENT_DROP_DB CONSTANT BINARY_INTEGER := 4;
13 EVENT_DEREG CONSTANT BINARY_INTEGER := 5;
14 EVENT_OBJCHANGE CONSTANT BINARY_INTEGER := 6;
15 EVENT_QUERYCHANGE CONSTANT BINARY_INTEGER := 7;
16 
17 ALL_OPERATIONS CONSTANT BINARY_INTEGER := 0;
18 ALL_ROWS CONSTANT BINARY_INTEGER := 1;
19 INSERTOP CONSTANT BINARY_INTEGER := 2;
20 UPDATEOP CONSTANT BINARY_INTEGER := 4;
21 DELETEOP CONSTANT BINARY_INTEGER := 8;
22 ALTEROP  CONSTANT BINARY_INTEGER := 16;
23 DROPOP   CONSTANT BINARY_INTEGER := 32;
24 UNKNOWNOP CONSTANT BINARY_INTEGER := 64;
25 
26 STRING_DOMAIN_SCHEMA CONSTANT BINARY_INTEGER :=0;
27 STRING_DOMAIN_DATABASE CONSTANT BINARY_INTEGER :=1;
28 STRING_DOMAIN_TABLE CONSTANT BINARY_INTEGER :=2;
29 
30 STRING_TRANSITIONAL_SEARCH CONSTANT BINARY_INTEGER :=0;
31 STRING_COMPLETE_SEARCH CONSTANT BINARY_INTEGER :=1;
32 
33  -- Notification Grouping Class
34   NTFN_GROUPING_CLASS_TIME CONSTANT BINARY_INTEGER := 1;
35 
36  -- Notification Grouping Type
37   NTFN_GROUPING_TYPE_SUMMARY CONSTANT BINARY_INTEGER := 1;
38   NTFN_GROUPING_TYPE_LAST    CONSTANT BINARY_INTEGER := 2;
39 
40  -- Notification Grouping Repeat Count
41   NTFN_GROUPING_FOREVER CONSTANT BINARY_INTEGER := -1;
42 
43 FUNCTION NEW_REG_START_OC4J(regds IN sys.chnf$_reg_info_oc4j)
44   RETURN NUMBER;
45 
46 FUNCTION NEW_REG_START(regds IN sys.chnf$_reg_info)
47   RETURN NUMBER;
48 
49 PROCEDURE ENABLE_REG(regid IN NUMBER);
50 
51 PROCEDURE REG_END;
52 
53 PROCEDURE DEREGISTER(regid IN NUMBER);
54 
55 PROCEDURE SET_ROWID_THRESHOLD(tbname IN varchar2, threshold IN NUMBER);
56  FUNCTION CQ_NOTIFICATION_QUERYID return number;
57 
58 END;