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
|