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