Output Tools - Call Procedure (OLEDB)

The versatile Stored Procedure Tool provides the ability to execute database stored procedures and functions to provide read, write and automated data processing. The Action supports any RDBMS with a functional OLEDB Provider thus enabling native support for a multitude of data sources. If a procedure generates a result set, the Tool can return this to other Tools for format and/or delivery. Conversely, the Tool can consume a result set 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.

Works with other Tools

These are other Tools that this Tool will interact directly with whether by exposing information to it or consuming information from it.

• Query Database
• Format as Text
• Format as HTML
• Run Crystal Report
• Flat File Import Tool

Dependencies

These are other products, technologies, protocols or systems that are required for the tool to work.

• Functional OLEDB Provider supporting exposure of Procedures and/or Functions.

Consumes

Objects that the Tool consumes that are exposed by other actions. Match these with `Exposes' in other Tool specifications.

• Recordset - Information Structured into Columns and Rows

Exposes

Objects that the Tool exposes that can be utilised by other tools. Match these with `Consumes' in other Tool specifications.

• Recordset - Information Structured into Columns and Rows