dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleCommand Class / ExecuteArray Method / ExecuteArray(Int32) Method
Number of times to execute SQL statement.

In This Topic
    ExecuteArray(Int32) Method
    In This Topic
    Executes SQL statement specified number of times.
    Syntax
    'Declaration
     
    Public Overloads Function ExecuteArray( _
       ByVal iters As Integer _
    ) As Integer
    public int ExecuteArray( 
       int iters
    )

    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.

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also