| General Information |
| Purpose |
because |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthxtr.sql |
| First Available |
11.2 |
Dependencies |
| DBA_APPLY |
DBMS_CAPTURE_ADM |
DBMS_UTILITY |
| DBA_CAPTURE |
DBMS_LOGREP_LIB |
DBMS_XSTREAM_ADM |
| DBA_STREAMS_RULES |
DBMS_LOGREP_UTIL |
GLOBAL_NAME |
| DBMS_APPLY_ADM |
DBMS_RULE_ADM |
XSTREAM$_SERVER |
| DBMS_APPLY_ADM_INTERNAL |
DBMS_STREAMS_ADM |
XSTREAM$_SUBSET_RULES |
| DBMS_ASSERT |
DBMS_STREAMS_ADM_UTL |
XSTREAM$_SYSGEN_OBJS |
|
| Security Model |
Execute is granted to
EXECUTE_CATALOG_ROLE role |
| |
| APPLY_EXISTS |
| Undocumented |
dbms_xstream_adm_utl.apply_exists(
svr_name IN VARCHAR2,
canon_svr_name OUT VARCHAR2)
RETURN BOOLEAN; |
| TBD |
| |
| CHECK_SVR_NAME |
| Undocumented |
dbms_xstream_adm_utl.check_svr_name(
svr_name IN VARCHAR2,
must_exist IN BOOLEAN,
canon_svr_name OUT VARCHAR2,
is_outbound IN BOOLEAN); |
| TBD |
| |
| CHECK_SVR_TYPE |
| Undocumented |
dbms_xstream_adm_utl.check_svr_type(
canon_svr_name IN VARCHAR2,
is_outbound IN BOOLEAN); |
| exec dbms_xstream_adm_utl.check_svr_type('ORA2MS', TRUE); |
| |
| DEL_GEN_RULE |
| Undocumented |
dbms_xstream_adm_utl.del_gen_rule(
rule_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| DEL_SUBSET_RULES |
Undocumented |
dbms_xstream_adm_utl.del_subset_rules(
canon_server_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2); |
| TBD |
| |
| DEL_XSERVER |
| Undocumented |
dbms_xstream_adm_utl.del_xserver(canon_server_name
IN VARCHAR2); |
| TBD |
| |
| DROP_GEN_RULE |
| Undocumented |
dbms_xstream_adm_utl.drop_gen_rule(
rule_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| DROP_OUTBOUND |
| Undocumented |
dbms_xstream_adm_utl.drop_outbound(
server_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
|
DROP_OUTBOUND_RULES |
| Undocumented |
dbms_xstream_adm_utl.drop_outbound_rules(
canon_svr_name IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| GET_CAP_N_QUEUE |
| Undocumented |
dbms_xstream_adm_utl.get_cap_n_queue(
canon_server_name IN VARCHAR2,
canon_capture OUT VARCHAR2,
canon_cap_src_db OUT VARCHAR2,
canon_queue_owner OUT VARCHAR2,
canon_queue_name OUT VARCHAR2); |
| TBD |
| |
|
GET_OUTBOUND_SRCDB |
| Undocumented |
dbms_xstream_adm_utl.get_outbound_srcdb(canon_server
IN VARCHAR2) RETURN VARCHAR2; |
| TBD |
| |
| GET_STREAMS_RULES |
| Undocumented |
dbms_xstream_adm_utl.get_streams_rule(...); |
| TBD |
| |
|
GET_SYSGEN_CAPTURE |
| Undocumented |
dbms_xstream_adm_utl.get_sysgen_capture(
canon_qowner IN VARCHAR2,
canon_qname IN VARCHAR2,
canon_cap_src_db OUT VARCHAR2)
RETURN VARCHAR2; |
| TBD |
| |
| HAS_TABLE_RULE |
| Undocumented |
dbms_xstream_adm_utl.has_table_rule(
canon_table_owner IN VARCHAR2,
canon_table_name IN VARCHAR2,
canon_strm_name IN VARCHAR2,
streams_type IN VARCHAR2)
RETURN BOOLEAN; |
| TBD |
| |
| INS_GEN_OBJ |
| Undocumented |
dbms_xstream_adm_utl.ins_gen_obj(
canon_server_name IN VARCHAR2,
canon_object_owner IN VARCHAR2,
canon_object_name IN VARCHAR2,
object_type IN VARCHAR2); |
| TBD |
| |
| INS_SUBSET_RULES |
Undocumented |
dbms_xstream_adm_utl.ins_subset_rules(
canon_server_name IN VARCHAR2,
ins_rule IN VARCHAR2,
upd_rule IN VARCHAR2,
del_rule IN VARCHAR2,
canon_invoker IN VARCHAR2); |
| TBD |
| |
| INS_XSERVER |
Undocumented |
dbms_xstream_adm_utl.ins_xserver(
canon_server_name IN VARCHAR2,
canon_app_src_db IN VARCHAR2,
canon_queue_owner IN VARCHAR2,
canon_queue_name IN VARCHAR2,
canon_capture_name IN VARCHAR2,
canon_cap_src_db IN VARCHAR2,
usr_comment IN VARCHAR2,
flags
IN VARCHAR2); |
| TBD |
| |
| IS_SYSGEN_OBJ |
| Undocumented |
dbms_xstream_adm_utl.is_sysgen_obj(
canon_object_owner IN VARCHAR2,
canon_object_name IN VARCHAR2,
object_type IN VARCHAR2)
RETURN BOOLEAN; |
| TBD |
| |
| NUM_SUBSCRIBERS |
Returns the number of subscribers on the named queue |
dbms_xstream_adm_utl.num_subscribers(canon_qowner
IN VARCHAR2, canon_qname IN VARCHAR2)
RETURN BINARY_INTEGER |
set serveroutput on
DECLARE
i PLS_INTEGER;
BEGIN
i := dbms_xstream_adm_utl.num_subscribers('UWCLASS', 'XQ');
dbms_output.put_line(i);
END;
/ |
| |
| REMOVE_GEN_RULE |
| Undocumented |
dbms_xstream_adm_utl.remove_gen_rule(
rule_name IN VARCHAR2,
streams_type IN VARCHAR2,
streams_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
inclusion_rule IN BOOLEAN); |
| TBD |
| |
| UPD_XSERVER |
| Undocumented |
dbms_xstream_adm_utl.upd_xserver(
canon_server_name IN VARCHAR2,
usr_comment IN VARCHAR2); |
| TBD |
| |
|
UPD_XSERVER_CAPINFO |
| Undocumented |
dbms_xstream_adm_utl.upd_xserver_capinfo(
canon_server_name IN VARCHAR2,
canon_capture IN VARCHAR2,
canon_cap_srcdb IN VARCHAR2,
comment IN
VARCHAR2); |
| TBD |
| |
|
VALID_SUBSET_RULES |
| Undocumented |
dbms_xstream_adm_utl.valid_subset_rules(
canon_svr_name IN VARCHAR2,
canon_ins_rule IN VARCHAR2,
canon_upd_rule IN VARCHAR2,
canon_del_rule IN VARCHAR2,
canon_rules_owner IN VARCHAR2)
RETURN BOOLEAN; |
| TBD |
