Oracle DBMS_CHAIN_invoker
Version 19.3

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 Internal support package for DBMS_SCHEDULER job chaining.
AUTHID CURRENT_USER
Dependencies
ALL_evaluation_context_VARS DBMS_ISCHED_CHAIN_condition PLITBLM
ALL_RULES DBMS_ISCHED_UTL RE$ATTRIBUTE_VALUE_LIST
ALL_RULE_SETS DBMS_LOCK RE$COLUMN_VALUE_LIST
ALL_RULE_SET_RULES DBMS_RULEADM_INTERNAL RE$NV_LIST
ALL_SCHEDULER_CHAINS DBMS_RULE_ADM RE$RULE_HIT
ALL_SCHEDULER_CHAIN_RULES DBMS_RULE_INTERNAL RE$RULE_HIT_LIST
ALL_SCHEDULER_CHAIN_STEPS DBMS_SCHEDULER RE$TABLE_VALUE_LIST
ANYDATA DBMS_STANDARD RE$VARIABLE_TYPE
DBMS_ASSERT DBMS_SYS_ERROR RE$VARIABLE_TYPE_LIST
DBMS_ISCHED DBMS_UTILITY SCHEDULER$_VAR_VALUE_LIST
Documented No
First Available 19c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthsch.plb
Subprograms
 
DEFINE_CHAIN_RULE (new 19c)
Define a single rule for a chain dbms_chain_invoker.define_chain_rule(
chain_name IN VARCHAR2,
condition  IN VARCHAR2,
action     IN VARCHAR2,
rule_name  IN VARCHAR2,
comments   IN VARCHAR2,
invoker    IN VARCHAR2,
sys_privs  IN BINARY_INTEGER,
cur_schema IN VARCHAR2);
TBD
 
DEFINE_CHAIN_STEP (new 19c)
Define a single step in a chain dbms_chain_invoker.define_chain_step(
chain_name      IN VARCHAR2,
step_name       IN VARCHAR2,
object_name     IN VARCHAR2,
event_step      IN BOOLEAN,
timeout         IN INTERVAL DAY TO SECOND,
event_condition IN VARCHAR2,
queue_spec      IN VARCHAR2,
invoker         IN VARCHAR2,
sys_privs       IN BINARY_INTEGER,
cur_schema      IN VARCHAR2);
TBD
 
DROP_CHAIN_RULE (new 19c)
Drop a single rule from a chain dbms_chain_invoker.drop_chain_rule(
chain_name  IN VARCHAR2,
rule_name   IN VARCHAR2,
force       IN BOOLEAN,
invoker     IN VARCHAR2,
sys_privs   IN BINARY_INTEGER,
cur_schema  IN VARCHAR2);
TBD
 
DROP_CHAIN_STEP (new 19c)
Drop a single step from a chain dbms_chain_invoker.drop_chain_step(
chain_name IN VARCHAR2,
step_name  IN VARCHAR2,
force      IN BOOLEAN,
invoker    IN VARCHAR2,
sys_privs  IN BINARY_INTEGER,
cur_schema IN VARCHAR2);
TBD
 
EVALUATE_RULESET (new 19c)
Evaluate a ruleset dbms_chain_invoker.evaluate_ruleset(
rule_set_name      IN  VARCHAR2,
evaluation_context IN  VARCHAR2,
event_context      IN  sys.re$nv_list,
table_values       IN  sys.RE$TABLE_VALUE_LIST,
column_value       IN  sys.RE$COLUMN_VALUE_LIST,
variable_values    IN  sys.SCHEDULER$_VAR_VALUE_LIST,
attribute_values   IN  sys.RE$ATTRIBUTE_VALUE_LIST,
stop_on_first_hit  IN  BOOLEAN,
simple_rules_only  IN  BOOLEAN,
true_rules         OUT sys.RE$RULE_HIT_LIST,
maybe_rules        OUT sys.RE$RULE_HIT_LIST);
TBD
 
PRE_CREATE_CHAIN (new 19c)
Undocumented dbms_chain_invoker.pre_create_chain(
chain_name          IN VARCHAR2,
rule_set_name       IN VARCHAR2,
evaluation_interval IN INTERVAL DAY TO SECOND,
comments            IN VARCHAR2,
invoker             IN VARCHAR2,
sys_privs           IN BINARY_INTEGER,
cur_schema          IN VARCHAR2);
TBD
 
PRE_DROP_CHAIN (new 19c)
Undocumented dbms_chain_invoker.pre_drop_chain(
chain_name IN VARCHAR2,
force      IN BOOLEAN,
invoker    IN VARCHAR2,
sys_privs  IN BINARY_INTEGER,
cur_schema IN VARCHAR2);
TBD
 
RUN_CHAIN (new 19c)
Run a scheduler job chain dbms_chain_invoker.run_chain(
chain_name  IN VARCHAR2,
start_steps IN VARCHAR2,
job_name    IN VARCHAR2,
invoker     IN VARCHAR2,
sys_privs   IN BINARY_INTEGER,
cur_schema  IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_SCHEDULER
What's New In 18c
What's New In 19c

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