Exec. Procedure
Kalipso - Form - Actions - Actions Description - Group Database - Exec. Procedure
Last updated
Kalipso - Form - Actions - Actions Description - Group Database - Exec. Procedure
Last updated
Executes a Stored Procedure in the Server's Database. You must import Stored Procedures (at the Database Connection Profile) before using this Action.
Action available for the following operating systems:
Stored Procedure - Stored Procedure to be executed.
Sources
Source <string> or <numeric> - Value to pass to the first Stored Procedure Parameter.
Targets
Column <unquoted string> - Name of the column to retrieve. This parameter is merely informative and has no impact whatsoever. What matters is the index of the Column. Therefore, this refers to the first returned Column.
Target <target> - Control or Variable where to save the value of the first returned Column.
Consider the following Database Table:
Products | ||
Code Numeric | Name String | Stock Numeric |
1 | Coca Cola | 100 |
2 | Pepsi Cola | 400 |
3 | Pork Chops | 300 |
Consider the following Stored Procedure who returns the stock of a given Product code:
getStock | |
Input Parameter | Parameter Type |
Code | Numeric |
Stored Procedure | getStock |
Parameter | Source |
Code | 1 |
Column | Target |
Stock | VAR(0) |
Result:
Variable | Value |
VAR(0) | 100 |
Notice that for this operation is necessary to create an ODBC Connnection and a Database Connection Profile.
See Stored Procedures chapter for more information.
Kalipso doesn't support Output Parameters so you have to delete them from the Stored Procedure's definitions inside your Project.
To return values from a Stored Procedure, just do a Select inside it.
