Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: