Call DB Procedure/Function
Description
Call DB Procedure/Function is a process entry in the Lookup Plugin for Process Studio Workflows. The Call DB Procedure/Function entry executes a database procedure (or function) and gets the result(s) back.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| 2 | Local Connection | Specify the name of the database connection on which the procedure resides. |
| 3 | Type | Select type of call you want to make, that is, either procedure or function. |
| 4 | Procedure name | Specify the name of the procedure or function to call. |
| 5 | Find it | Click to search available procedures and functions (Oracle and SQL Server only; With MySQL and JDBC, it is not possible to retrieve the result set of a stored procedure.) |
| 6 | Enable auto commit | In some instances, you want to perform updates. Commit in the database using the specified procedure. You can either have the changes performed using auto-commit or not. If auto-commit is disabled, a single commit is performed after the last row is received by the entry. |
| 7 | Result name | Specify a PS Variable in result name field starting with Local or Global.For example, Local.userId Note: The field is unavailable if you select Procedure in the Type field. |
| 8 | Result type | Specify a field to store the Type of the result of the function call. Note: The field is unavailable if you selected Procedure in the Type field. |
| 9 | Parameters | Provide a list of parameters that the procedure or function requires. - Parameter Name: Specify either Local or Global PS variables. For example, - Direction: Select any of the following: o IN (input only) o OUT (output only) o INOUT (value is changed in the database) - Type: Used for output parameters so that Process Studio knows what data type returns. |