9.4 EXECUTE Procedure Signature 1
This procedure executes an automation.
Syntax
APEX_AUTOMATION.EXECUTE (
p_application_id IN NUMBER DEFAULT {current application id},
p_static_id IN VARCHAR2,
p_filters IN apex_exec.t_filters DEFAULT apex_exec.c_empty_filters,
p_order_bys IN apex_exec.t_order_bys DEFAULT apex_exec.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.
|
Example
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;
Parent topic: APEX_AUTOMATION