Oracle | DBMS_STREAMS_ADM_UTL

Oracle DBMS_STREAMS_ADM_UTL_INVOK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Streams Administrative Internal Utilities

AUTHID CURRENT_USER

Dependencies

AQ$_AGENT	DBMS_LOGREP_UTIL	DBMS_STREAMS_RPC
DBMS_APPLY_ADM	DBMS_LOGREP_UTIL_INVOK	DBMS_SYSTEM
DBMS_APPLY_ADM_INTERNAL	DBMS_PRIV_CAPTURE	DBMS_SYS_ERROR
DBMS_APPLY_ADM_IVK	DBMS_RULE_ADM	DBMS_UTILITY
DBMS_AQADM_SYS	DBMS_STANDARD	DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM	DBMS_STREAMS	DBMS_XSTREAM_GG_ADM
DBMS_CAPTURE_ADM_INTERNAL	DBMS_STREAMS_ADM	DBMS_XSTREAM_GG_INTERNAL
DBMS_CAPTURE_ADM_IVK	DBMS_STREAMS_ADM_IVK	DBMS_XSTREAM_UTL_IVK
DBMS_COMPARISON	DBMS_STREAMS_ADM_UTL	RE$VARIABLE_TYPE
DBMS_INTERNAL_TRIGGER	DBMS_STREAMS_DECL	RE$VARIABLE_TYPE_LIST
DBMS_LOGREP_LIB	DBMS_STREAMS_MT

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthstr.plb

Subprograms

ADD_MESSAGE_RULE	CREATE_STREAMS_PROCESS	GET_PERFORMANCE_REPORT
ADD_OBJECT_CONSTRAINT	DROP_OBJECT_CONSTRAINT	HAS_PRIVS_FOR_TAG
ADD_STREAMS_RULE	GATHER_PERFORMANCE_STATISTICS	SET_CONSTRAINT_COLUMNS
CANON_PROC_NAME

ADD_MESSAGE_RULE

Undocumented dbms_streams_adm_utl_invok.add_message_rule( message_type IN VARCHAR2, rule_condition IN VARCHAR2, streams_type IN VARCHAR2, streams_name IN VARCHAR2, queue_name IN VARCHAR2, inclusion_rule IN BOOLEAN, rule_name OUT VARCHAR2);

TBD

ADD_OBJECT_CONSTRAINT

Undocumented dbms_streams_adm_utl_invok.add_object_constraint( object_name IN VARCHAR2, parent_object_name IN VARCHAR2);

TBD

ADD_STREAMS_RULE

Undocumented dbms_streams_adm_utl_invok.add_streams_rule( rule_type IN NUMBER, rule_object IN VARCHAR2, streams_type IN VARCHAR2, streams_name IN VARCHAR2, queue_name IN VARCHAR2, include_dml IN BOOLEAN, include_ddl IN BOOLEAN, include_procedure IN BOOLEAN, include_tag_on IN BOOLEAN, source_database IN VARCHAR2, and_condition IN VARCHAR2, canon_invoker IN VARCHAR2, inclusion_rule IN BOOLEAN, canon_dml_rule_name OUT VARCHAR2, canon_ddl_rule_name OUT VARCHAR2, canon_procedure_rule_name OUT VARCHAR2, source_root_name IN VARCHAR2, package_owner IN VARCHAR2, package_name IN VARCHAR2, procedure_name IN VARCHAR2, null_package_name IN BOOLEAN);

TBD

CANON_PROC_NAME

Undocumented dbms_streams_adm_utl_invok.canon_proc_name( user_procedure IN VARCHAR2, parameter_name IN VARCHAR2, canon_user_procedure OUT VARCHAR2);

TBD

CREATE_STREAMS_PROCESS

Undocumented dbms_streams_adm_utl_invok.create_streams_process( canon_queue_owner IN VARCHAR2, canon_queue_name IN VARCHAR2, canon_streams_name IN VARCHAR2, streams_type IN NUMBER, rules IN sys.dbms_utility.lname_array, num_rules IN NUMBER, inclusion_rule IN BOOLEAN, canon_invoker IN VARCHAR2, canon_out_streams_name OUT VARCHAR2, apply_captured IN BOOLEAN, canon_src_db IN VARCHAR2, canon_src_root IN VARCHAR2);

TBD

DROP_OBJECT_CONSTRAINT

Undocumented dbms_streams_adm_utl_invok.drop_object_constraint( object_name IN VARCHAR2, parent_object_name IN VARCHAR2);

TBD

GATHER_PERFORMANCE_STATISTICS

Undocumented dbms_streams_adm_utl_invok.gather_performance_statistics( cursor_type IN NUMBER, component_cursor IN OUT sys_refcursor);

TBD

GET_PERFORMANCE_REPORT

Undocumented dbms_streams_adm_utl_invok.get_performance_report(task_id IN NUMBER);

TBD

HAS_PRIVS_FOR_TAG

Undocumented dbms_streams_adm_utl_invok.has_privs_for_tag RETURN BOOLEAN;

BEGIN

        IF dbms_streams_adm_utl_invok.has_privs_for_tag THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

SET_CONSTRAINT_COLUMNS

Undocumented

Overload 1 dbms_streams_adm_utl_invok.set_constraint_columns( constraint_name IN VARCHAR2, object_name IN VARCHAR2, column_list IN VARCHAR2);

TBD

Overload 2 dbms_streams_adm_utl_invok.set_constraint_columns( constraint_name IN VARCHAR2, object_name IN VARCHAR2, column_table IN sys.dbms_utility.name_array);

TBD