9.5 EXECUTE Procedure Signature 2

This procedure executes an automation.

Syntax

APEX_AUTOMATION.EXECUTE (
    p_application_id    IN NUMBER DEFAULT wwv_flow.g_flow_id,
    p_static_id         IN VARCHAR2,
    p_run_in_background IN BOOLEAN )

Parameters

Parameter	Description
p_application_id	ID of the application which contains the automation.
p_static_id	Static ID of the automation to execute.
p_run_in_background	If TRUE, synchronization runs in the background as a one-time DBMS_SCHEDULER job.

Example

This example executes the automation my_emp_table_automation in the background.

BEGIN
    apex_session.create_session( 100, 1, 'ADMIN' );

    apex_automation.execute(
        p_static_id         => 'my_emp_table_automation',
        p_run_in_background => true );
END;