11.5 GET_CURRENT_EXECUTION Function

This function returns the status of the current execution. This functiuon is called from within the background process to get its own execution ID.

If the function is called from a page process running in the background, returns an empty record.

Syntax

APEX_BACKGROUND_PROCESS.GET_CURRENT_EXECUTION
    RETURN t_execution;

Parameters

None.

Returns

T_EXECUTION record with status information for the current execution.

Example

The following example retrieves Status information of the currently running background execution.

DECLARE
    l_execution apex_background_process.t_execution;
BEGIN
    l_execution := apex_background_process.get_current_execution;
    sys.dbms_output.put_line( 'Execution ID: ' || l_execution.id );
END;

=> Execution ID: 4711