Oracle | DBMS_STREAMS_ADM_UTL

Oracle DBMS_STREAMS_ADM_UTL_INVOK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Streams Administrative Internal Utilities

AUTHID CURRENT_USER

Dependencies

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

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the OGG_APPLY and OGG_CAPTURE roles.

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