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.


In This Article


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?'