Oracle | DBMS_ISCHED_CHAIN

Oracle DBMS_ISCHED_CHAIN_CONDITION Version 23c

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

STEP_TABLE_POPULATED

TRANSFORM_CHAIN_CONDITION

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;

      *

      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