Gets or sets the maximum size, in bytes, of the data within the column.
Assembly: System.Data.OracleClient (in System.Data.OracleClient.dll)
Property ValueType: System.Int32
The maximum size, in bytes, of the data within the column. The default value is 0 (to be used when you do not want to specify the maximum size of the value).
Setting affects only the input value of a parameter. Return values and output parameters are not affected by this property.
The property is used for binary and string types.
For nonstring data types and ANSI string data, the property refers to the number of bytes. For Unicode string data, refers to the number of characters. The count for strings does not include the terminating character.
For variable-length data types, describes the maximum amount of data to transmit to the server. For example, for a Unicode string value, could be used to limit the amount of data sent to the server to the first one hundred characters.
For bidirectional and output parameters, and return values, you must set the value of Size. This is not required for input parameters, and if not explicitly set, the value of is inferred from the actual size of the specified parameter when a parameterized statement is executed.
The DbType, OracleType, and properties of a parameter can be inferred by setting Value. Therefore, you are not required to specify them. However, they are not exposed in OracleParameter property settings. For example, if the size of the parameter has been inferred, does not contain inferred value after statement execution.
For fixed length data types, the value of is ignored. It can be retrieved for informational purposes, and returns the maximum amount of bytes the provider uses when transmitting the value of the parameter to the server.
The following example creates a OracleParameter and sets some of its properties.
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.