11.6 GET_EXECUTION Function

This function returns the current status of a specific execution ID.

Syntax

APEX_BACKGROUND_PROCESS.GET_EXECUTION (
    p_application_id     IN NUMBER DEFAULT apex_application.g_flow_id,
    p_execution_id       IN NUMBER )
    RETURN t_execution;

Parameters

Parameter	Description
p_application_id	ID of the application containing the process.
p_execution_id	ID of the execution to get status for.

Returns

This function returns t_execution record with current status information for this execution.

Example

The following example retrieves Status information for execution ID 4711.

DECLARE
    l_execution apex_background_process.t_execution;
BEGIN
    l_execution := apex_background_process.get_execution(
                   p_application_id     => 100,
                   p_execution_id       => 4711 );

    sys.dbms_output.put_line( 'Execution State: ' || l_execution.state );
END;

=> Execution State: EXECUTING