ArrayLength Property

In This Topic

Gets or sets the length of the DML array, PL/SQL table, or VARRAY and TABLE object types.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ArrayLength As Integer

public int ArrayLength {get; set;}

Property Value

A length of the DML array or PL/SQL table, or VARRAY and TABLE object types.

Remarks

An array length representing a value of DML array or PL/SQL table, or VARRAY and TABLE object types is set equal to a value of the ArrayLength property. If you use DML array or PL/SQL table output parameter you must obligatory set ArrayLength property. If you use output parameter of VARRAY or TABLE type ArrayLength property will be set automatically after command execution.

For PL/SQL parameters, only the following data types are allowed: Boolean, VarChar, Char, NVarChar, NChar, Number, Integer, Double, Float, Date.

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

Reference

OracleParameter Class
OracleParameter Members

Send Feedback