Oracle DBMS_CHAIN_INVOKER
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 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
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
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
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
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
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
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
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
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 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