Stored Procedure

The Stored Procedure task executes a stored procedure within a supported Database Server. Supports stored procedures for Oracle, MSSQL and PostgreSQL databases.

All of the fields described in this page are specific to this service. To get general information for setting up a task, see Tasks.

Stored Procedure Properties

This table describes the Stored Procedure task properties:

Field	Description
Database	The SQL database associated with the login. Only needed if the login is a MSSQL Database Login.
Procedure	Name of the stored procedure to be executed. Parameters for the stored procedure are returned once the stored procedure is selected. Clicking on the magnifying glass displays a search dialog from which you select the stored procedure. In the search field you can use sql wildcards such as % and _ to filter on the database server the list of stored procedures returned. The list of stored procedures is restricted by the security permissions of the login that is used to access the database.
Timeout	The maximum time to wait for the specified stored procedure to complete before timing out. This overrides the database server's default timeout. If the query exceeds the time specified, the task status is set to ERROR and a message is logged, indicating that the query timed-out.
Parameters	Parameters of the stored procedure. See the Parameters Section for more information.

Stored Procedure Login

Use SQL Login to run stored procedure. The server type should be selected as JDBC for the Java Agent. For the .NET Agent, the server type should be Microsoft SQL Server, Oracle, Other SQL Server or PostgreSQL depending on the database the user connects to. See the SQL Login for more information.

Parameters Section

This section contains a list of parameters for the stored procedure. It is automatically populated when the stored procedure is selected. The parameter table contains parameter properties:

Field	Description
Name	Name of the parameter returned.
Type	The external data type of the parameter.
Direction	Indicates if the parameter is an input (IN), output (OUT) or input and output (IN-OUT) parameter.
Value	Current value defined for the parameter. This value can be modified.

See Creating a Process to add this task to a process.