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

Direct access to some objects in this package is prevented by means of an Accessible By clause.
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx