Stored Procedure

This AgileShape can be used to execute dynamic SQL statements and/or call database stored procedures.

This AgileShape does not support capturing return values or output parameters. See the Query Database AgileShape for additional information about retrieving data from the database.

Properties for This AgilePart

Field Name	Definition
Configure	Opens the Configuration for Stored Procedure or Generic SQL dialog box, where you can configure where and how the new database records are inserted into the database.
DatabaseType	The type of database that will be used.
Timeout	Default value: 600 Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the web service call for this AgileShape.

Field Name

Definition

Configure

Opens the Configuration for Stored Procedure or Generic SQL dialog box, where you can configure where and how the new database records are inserted into the database.

DatabaseType

The type of database that will be used.

Timeout

Default value: 600

Specifies the maximum amount of time (in seconds) that should be allowed for the completion of the web service call for this AgileShape.

Common AgilePart Properties

The properties of the basic AgilePart AgileShape are also included in this AgileShape. For more information, see AgilePart.