Oracle | DBMS_CHAIN

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