Follow-On Topics

Related Topics

# About Call Stored Procedure Memory

The Call Stored Procedure memory provider allows the user to record information about a task run in any compliant OLEDB data source by executing a Stored Procedure; mapping values to the procedure parameters. The Stored Procedure is responsible for storing the parameters in whatever format is required. Transaction options allow a procedure execution to only be committed upon criteria being met, such as a successful or failed iteration, or based upon a rule. Features include:
|  | Memorise data using an OLEDB compliant data source supporting stored procedures
|  | Map values to procedure parameters
|  | Transaction support
|  | Memorise based upon VBScript rules
| Click the image to view full size.

## Global Configuration

In order to be able to create a new Call Stored Procedure memory definition, a connection to an OLEDB compliant data source must be available or selection or configured through the OLEDB Connections dialog box.

In addition, the user must also have permission to use the memory definition. This is configured in the Memory Access tab of the User Properties dialog box.

Any number of connections can be made and access to each one may be controlled through a user name and password if required.

## Dialog Boxes

The Call Stored Procedure Memory dialog box is displayed when the Add button is selected in the Memory Definitions dialog box and the Call Stored Procedure Memory option is selected in the Please select a Memory Provider dialog box. Alternatively it may be displayed by selecting an existing Call Stored Procedure Memory definition in the Memory Definitions dialog box and selecting the Edit button.

The dialog box contains the following two tabbed panes which are used to configure a Call Stored Procedure Memory Definition:

|  | Memory

|  | Options

Copyright © 2018 Quadrant Software B.V. All rights reserved.