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 will be available on generic Linux platforms in January and soon on AIX and Windows

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