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
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_UTIL_INT
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx