Oracle DBMS_STREAMS_ADM_UTL_INVOK
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx