APEX_AUTOMATION Package

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

APEX_AUTOMATION Package

Post by admin »

The APEX_AUTOMATION package provides automated functionality to your environment. Automations are a sequential set of actions that are triggered by query results. Use automation to monitor data and then perform the appropriate action, such as auto-approving specific requests and sending email alerts.

VIDEO
https://youtu.be/jq2uMbrxTds

DISABLE Procedure
ENABLE Procedure
EXECUTE Procedure
EXECUTE for Query Context Procedure
EXIT Procedure
GET_LAST_RUN Return Function
GET_LAST_RUN_TIMESTAMP Function
LOG_ERROR Procedure
LOG_INFO Procedure
LOG_WARN Procedure
RESCHEDULE Procedure
SKIP_CURRENT_ROW Procedure

BEGIN
apex_automation.enable(
p_application_id => 75605,
p_static_id => 'expenses' );
END;

BEGIN
apex_automation.disable(
p_application_id => 75605,
p_static_id => 'expenses' );
END;

-- 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;
https://docs.oracle.com/en/database/ora ... 730775ABE7
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest