Contents
Display Legacy Contents

 Print
    Exec. Procedure  
Executes a Stored Procedure in the Server's Database. You must import Stored Procedures (at the Database Connection Profile) before using this Action.

Parameters

Stored Procedure

Stored Procedure to be executed.
 
 
Sources
  Source <string> or <numeric>
 
Value to pass to the first Stored Procedure Parameter.
 
 
  (...) 
 
 
  Nth-Source <string> or <numeric>
 
Value to pass to the nth 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.
 
 
  (...)
 
 
  Nth-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 nth returned Column.
 
 
  Nth-Target <target>
 
Control or Variable where to save the value of the nth 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

Example 1
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.

See also
Samples

 
 
Updated: 3/21/2018 5:46 PM