Oracle | DBMS_ISCHED_CHAIN

Oracle DBMS_ISCHED_CHAIN_CONDITION Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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 this package is prevented by 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;

           *

      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