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
|