59.23 UPDATE_VARIABLES Procedure

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.

Syntax

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

Parameters

Parameter	Description
p_instance_id	ID of the Workflow.
p_changed_params	Table of Workflow variables to be updated.

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;