Executing PL/SQL Functions and Creating Transitions Based on Results

PL/SQL function execution workflow steps are used when a workflow needs to 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 4-5. Execution window values for executing PL/SQL functions.

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

Field Name

Description

Name

Type a descriptive name for the workflow step source.

Workflow Scope

Packages

Execution Type

PL/SQL Function

Processing Type

Manual or Immediate

Validation

Selects or creates a validation that includes all the possible values of the SQL query.

You can create a validation validated by SQL. Use the same SQL from the execution minus the WHERE clause.

Execution

Type the SQL query.

Enabled

Yes