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.
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);
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);
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);
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);
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);
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);
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);
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);