This procedure updates workflow variables of the workflow instance. If the Workflow variable has a format mask set, the same mask is applied to the value being passed here.

The logged-in user must be a Workflow Administrator to execute this API. This procedure can only run for workflows in Suspended or Faulted states.

Syntax

APEX_WORKFLOW.UPDATE_VARIABLES (
    p_instance_id            IN NUMBER,
    p_changed_params         IN t_workflow_parameters );

Parameters

Example

The following example updates a Workflow variable value.

BEGIN
    apex_workflow.update_variables(
           p_instance_id => 1234,
           p_changed_params => apex_workflow.t_workflow_parameters(
               1 => apex_workflow.t_workflow_parameter(static_id => 'NEW_SALARY', string_value => '2,560.50')));
END;