PACKAGE: SYS.DBMS_PROPAGATION_ADM

Source

1 PACKAGE dbms_propagation_adm AUTHID CURRENT_USER AS
2 
3   PROCEDURE create_propagation(
4        propagation_name          IN VARCHAR2,
5        source_queue              IN VARCHAR2,
6        destination_queue         IN VARCHAR2,
7        destination_dblink        IN VARCHAR2  DEFAULT NULL,
8        rule_set_name             IN VARCHAR2  DEFAULT NULL,
9        negative_rule_set_name    IN VARCHAR2  DEFAULT NULL,
10        queue_to_queue            IN BOOLEAN   DEFAULT NULL,
11        -- The following two parameters are ONLY used by
12        -- split-merge api
13        original_propagation_name IN VARCHAR2  DEFAULT NULL,
14        auto_merge_threshold      IN NUMBER    DEFAULT NULL);
15 
16   PROCEDURE alter_propagation(
17        propagation_name         IN VARCHAR2,
18        rule_set_name            IN VARCHAR2 DEFAULT NULL,
19        remove_rule_set          IN BOOLEAN  DEFAULT FALSE,
20        negative_rule_set_name   IN VARCHAR2 DEFAULT NULL,
21        remove_negative_rule_set IN BOOLEAN  DEFAULT FALSE);
22 
23   PROCEDURE drop_propagation(
24        propagation_name      IN VARCHAR2,
25        drop_unused_rule_sets IN BOOLEAN DEFAULT FALSE);
26 
27   PROCEDURE stop_propagation(
28        propagation_name      IN VARCHAR2,
29        force                 IN BOOLEAN DEFAULT FALSE);
30 
31   PROCEDURE start_propagation(
32        propagation_name      IN VARCHAR2);
33 
34 END dbms_propagation_adm;