6.12 GET_TASK_HISTORY Function

This function gets the approval log for a task.

This function only returns data in the context of a valid Oracle APEX session. It returns no data in SQL Workshop.

Syntax

APEX_APPROVAL.GET_TASK_HISTORY (
    p_task_id        IN NUMBER )
RETURN wwv_flow_t_approval_log_table pipelined;

Parameters

Table 6-10 GET_TASK_HISTORY Parameters

Parameter	Description
p_task_id	The task ID.

Returns

A table of log entries (type apex_t_approval_log).

Example

select * from table ( apex_approval.get_task_history ( p_task_id => 1234 ) )