Description

The StoredProcedureCallReceiver calls a stored procedure with or without parameters via JDBC. It executes a stored procedure as a closed system, meaning it does not expect any returned values.

Receiver Parameters

The StoredProcedureCallReceiver requires that the following parameters are defined:

• resourceName - Defines the name of the resource that contains the database connection information on a user's local machine.
• databaseName - Defines the name of the database to access.
• procedureName - Defines the name of the stored procedure to call.
  

Receiver Attribute Property Keys

The Receiver defines four property keys that can be modified on any of its associated Domain Attributes:

• use - Specifies whether or not to use the given Attribute's value as a parameter value in the store procedure call.
• position - Specifies the position of the parameter value within the store procedure call. This parameter must be defined if 'use' is equal to true.
• type - Specifies the parameter type. This parameter must be defined if 'use' is equal to true.
• size - The size of the type.
  

Type Value

The column data types are the following:

• VarChar - native data type
• Boolean - native data type
• BigDecimal - gets translated to a DECIMAL
• Date - native data type
• Double - native data type
• Float - native data type
• Integer - native data type
• Long - gets translated to a BIGINT
• Time - native data type
• Timestamp - native data type

JDBC Configuration File

This Receiver utilizes a configuration file stored locally on the user's computer or a shared test server to obtain the necessary information to connect to a specific database via JDBC. For detailed information, refer to 'What is a JDBC Config File?'