ExecuteArray(Int32) Method

In This Topic

Syntax
Remarks
See Also

Executes SQL statement specified number of times.

Syntax

Visual Basic
C#

public int ExecuteArray( 
   int iters
)

'Declaration
 
Public Overloads Function ExecuteArray( _
   ByVal iters As Integer _
) As Integer

Parameters

iters: Number of times to execute SQL statement.

Return Value

The return value is the number of rows affected by the statement.

Remarks

The ExecuteArray method allows to execute several SQL statements for the one time. The main advantage of using this method is that only one round trip to the server is used to execute several queries, which speeds up queries execution compared to consecutive invocation.

All parameters of the query must have System.Array type and an elements of the array must have type corresponding to the type of the parameter. The value of the iters parameter must be equal to the number of elements of the array.

Refer to "Working with Array Binding" article for detailed information and example.

Reference

OracleCommand Class
OracleCommand Members
Overload List

Send Feedback