Execute 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 Tool 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.
» Third party product and technology license disclaimerDownload Resources
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.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



