- TIBCO BusinessEvents®
- RDBMS
- Database

# Database.executePreparedStmtByParamList()

## Signature

`int executePreparedStmtByParamList(String preparedStmt, List parameterList)`

## Domain

ACTION, CONDITION, BUI

## Description

Executes a PreparedStatement. A prepared statement is a SQL statement where values are determined at runtime.
The values to be used are passed as a List of parameters.

## Parameters

Name | Type | Description
--- | --- | ---
`preparedStmt` | `String` | The SQL prepared statement to execute
`parameterList` | `List` | Positional values to be used for binding to the prepared statement. An ArrayList that has been populated using preparedstatement utility methods only (addIntPreparedStmtParam, addStringPreparedStmtParam etc).

## Returns

Type | Description
--- | ---
`int` | Total number of records affected by the prepared statement

## Cautions

none