Oracle | DBMS_CHAIN

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	DROP_CHAIN_STEP	PRE_DROP_CHAIN
DEFINE_CHAIN_STEP	EVALUATE_RULESET	RUN_CHAIN
DROP_CHAIN_RULE	PRE_CREATE_CHAIN

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