Follow-On Topics

Related Topics

# About the Call Stored Procedure (OLEDB) Tool

The Call Stored Procedure (OLEDB) Tool is used to create a Task Step that allows the execution of database stored procedures and functions to provide read, write and automated data processing.

If a procedure generates a recordset, the Step can return this to other Steps for format and/or delivery. Conversely, the Step can consume a recordset to enable multiple procedure calls or indeed simply execute a single procedure. Procedure calls can be passed static or dynamic parameters in order to control the precise nature of the call being made.

The features provided by the Call Stored Procedure (OLEDB) Tool therefore mean that it may be used as an Input, Output or Execute type Step within a Task.

The Tool supports any RDBMS with a functional OLEDB Provider, thus enabling native support for a multitude of data sources.

## Features

|  | Calls stored procedures from a multitude of data sources

|  | Allows manual or dynamic inputting of procedure parameters

|  | Contains memory features to memorise Task data created at run time

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