11.17 TERMINATE Procedure

This procedure terminates a currently executing automation.

Syntax

APEX_AUTOMATION.TERMINATE (
    p_application_id    IN NUMBER   DEFAULT {current application id},
    p_static_id         IN VARCHAR2 )

Parameters

Parameter	Description
p_application_id	ID of the application which contains the automation.
p_static_id	Static ID of the automation to terminate.

Example

The following example terminates the currently executing automation my_emp_table_automation in application 152. If the automation is not running, nothing happens.

BEGIN
    apex_automation.terminate(
        p_application_id => 152,
        p_static_id      => 'my_emp_table_automation' );
END;