SetIntParameterByName()

Use the SetIntParameterByName() method to configure an integer parameter by the name encoded into the text of a SQL statement using the @ character.

Note: Use this method for the Oracle data type Boolean.It is specific to Oracle.

Syntax

result SetIntParameterByName (
string ParameterName,
object ParameterValue,
aaDBParameterDirection ParameterDirection)

Parameters

ParameterName

The string identifier that is used in the SQL statement.

In the following SQL statement the name of the output parameter is "Cnt"

"SELECT @Cnt=Count (*)(RejectedQty)

FROM Person.Contact "

ParameterValue

An integer value or a valid ArchestrA reference string. For example:

• 10

• me.OrderCount

• Null - Output

ParameterDirection

For possible values, see aaDBParameterDirection.

Example

SetIntParameterByName ("Cnt", null, aaDBParameterDirection.Output)