Oracle DBMS_ISCHED_CHAIN_CONDITION
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 An undocumented internal package with 1 procedure and 2 functions.
AUTHID DEFINER
Data Types TYPE step_name_array ....
Dependencies
DBMS_CHAIN_INVOKER DBMS_SYSTEM DBMS_UTILITY
DBMS_ISCHED DBMS_SYS_ERROR PLITBLM
DBMS_STANDARD    
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthsch.plb
Subprograms
 
DELETE_STEP_NAME_TABLE
Delete the chain step table

Protected by an ACCESSIBLE BY clause
dbms_isched_chain_condition.delete_step_name_table;
exec dbms_isched_chain_condition.delete_step_name_table;
BEGIN dbms_isched_chain_condition.delete_step_name_table; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object DELETE_STEP_NAME_TABLE
 
STEP_TABLE_POPULATED
Returns TRUE if the chain step table is populated dbms_isched_chain_condition.step_table_populated(chain IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF dbms_isched_chain_condition.step_table_populated('TEST_CHAIN') THEN
    dbms_output.put_line('Chain Table Is Populated');
  ELSE
    dbms_output.put_line('Chain Table Is Not Populated');
  END IF;
END;
/
Chain Table Is Not Populated

PL/SQL procedure successfully completed.
 
TRANSFORM_CHAIN_CONDITION
Undocumented dbms_isched_chain_condition.transform_chain_condition(
condition    IN VARCHAR2,
chain_owner  IN VARCHAR2,
chain_object IN VARCHAR2,
throw_error  IN BOOLEAN,
sys_trace    IN BOOLEAN,
step_name    IN sys.dbms_isched_chain_condition.step_name_array)
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_ISCHED
DBMS_ISCHEDFW
DBMS_ISCHED_AGENT
DBMS_SCHEDULER
DBMS_SCHED_ARGUMENT_IMPORT
DBMS_SCHED_ATTRIBUTE_EXPORT
DBMS_SCHED_FILE_WATCHER_EXPORT
What's New In 19c
What's New In 20c-21c

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