Executing PL/SQL Functions and Creating Transitions Based on the Results

PL/SQL function execution workflow steps are used when a workflow must be routed based on the results of the PL/SQL function. A PL/SQL function execution workflow step runs a PL/SQL function and returns its results as the result of that workflow step.

Create a new execution step source with the field values as defined in Table 7-4. Execution window values for executing PL/SQL functions.

Table 7-4. Execution window values for executing PL/SQL functions

Field Name

Description

Name

Type a descriptive name for the step source.

Workflow Scope

Requests

Reference Code

Accept the default value, or type a different reference code

Execution Type

PL/SQL Function

Processing Type

Manual or Immediate

Validation

Selects or creates a validation that includes all of the possible values of the SQL query. You can also create a validation validated by SQL. Use the same SQL from the execution minus the WHERE clause.

Execution

Type the PL/SQL function.

Enabled

Yes