René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

dbms_cdc_subscribe

Procedures/Functions

activate_subscription

procedure activate_subscription (
 subscription_name                  in                 varchar2        
);
procedure activate_subscription (
 subscription_handle                in                   number        
);

create_subscription

procedure create_subscription (
 change_set_name                    in                 varchar2        ,
 description                        in                 varchar2        ,
 subscription_name                  in                 varchar2        
);

drop_subscriber_view

procedure drop_subscriber_view (
 subscription_handle                in                   number        ,
 source_schema                      in                 varchar2        ,
 source_table                       in                 varchar2        
);

drop_subscription

procedure drop_subscription (
 subscription_name                  in                 varchar2        
);
procedure drop_subscription (
 subscription_handle                in                   number        
);

extend_window

procedure extend_window (
 subscription_name                  in                 varchar2        
);
procedure extend_window (
 subscription_handle                in                   number        
);

get_subscription_handle

procedure get_subscription_handle (
 change_set                         in                 varchar2        ,
 description                        in                 varchar2        ,
 subscription_handle               out                   number        
);

prepare_subscriber_view

procedure prepare_subscriber_view (
 subscription_handle                in                   number        ,
 source_schema                      in                 varchar2        ,
 source_table                       in                 varchar2        ,
 view_name                         out                 varchar2        
);

purge_window

procedure purge_window (
 subscription_name                  in                 varchar2        
);
procedure purge_window (
 subscription_handle                in                   number        
);

subscribe

procedure subscribe (
 subscription_name                  in                 varchar2        ,
 source_schema                      in                 varchar2        ,
 source_table                       in                 varchar2        ,
 column_list                        in                 varchar2        ,
 subscriber_view                    in                 varchar2        
);
procedure subscribe (
 subscription_name                  in                 varchar2        ,
 publication_id                     in                   number        ,
 column_list                        in                 varchar2        ,
 subscriber_view                    in                 varchar2        
);
procedure subscribe (
 subscription_handle                in                   number        ,
 source_schema                      in                 varchar2        ,
 source_table                       in                 varchar2        ,
 column_list                        in                 varchar2        
);
procedure subscribe (
 subscription_handle                in                   number        ,
 publication_id                     in                   number        ,
 column_list                        in                 varchar2        
);

Links