Call DB Procedure/Function
Description
Call DB Procedure/Function is a step in the Lookup Plugin for Process Studio Workflows. The Call DB Procedure/Function step executes a database procedure (or function) and gets the result(s) back.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 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 DBC, 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 this step. |
| 7 | Result name | Specify a field to store the result of the function call. Note: The field is unavailable if you selected 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 | Stored procedures and functions can only return values through their function arguments and those arguments must be defined in the Parameters section of the DB Procedure Call configuration. Provide a list of parameters that the procedure or function needs in this section - Parameter name: Name of the field. - Direction: Can be either IN (input only), OUT (output only), INOUT (value is changed on the database). - Type: Used for output parameters so that Process Studio knows what data type returns. |
| 10 | Get Fields | Fills in all the fields in the input streams to make your life easier; delete the lines you don't need and re-order the remaining lines |