EXECUTE Procedure

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_filters           IN wwv_flow_exec_api.t_filters   DEFAULT wwv_flow_exec_api.c_empty_filters,
    p_order_bys         IN wwv_flow_exec_api.t_order_bys DEFAULT wwv_flow_exec_api.c_empty_order_bys );

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_filters`	Additional filters to apply to the automation query.
`p_order_bys`	`ORDER BY` clauses to apply to the automation query.

Examples

This example executes the automation my_emp_table_automation and applies a filter to the automation query on the DEPTNO column (DEPTNO = 10).

DECLARE
    l_filters apex_exec.t_filters;
BEGIN
    apex_session.create_session( 100, 1, 'ADMIN' );

    apex_exec.add_filter(
        p_filters        => l_filters,
        p_column_name    => 'DEPTNO',
        p_filter_type    => apex_exec.c_filter_eq,
        p_value          => 10 );

    apex_automation.execute(
        p_static_id       => 'my_emp_table_automation',
        p_filters         => l_filters );
END;