This documentation is archived and is not being maintained.

OracleParameter.Size Property

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Gets or sets the maximum size of the data within the column.

[Visual Basic]
Public Overridable Property Size As Integer  Implements _
public virtual int Size {get; set;}
public: __property virtual int get_Size();
public: __property virtual void set_Size(int);
public function get Size() : int;
public function set Size(int);

Property Value

The maximum size 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 Size affects only the input value of a parameter. Return values and output parameters are not affected by this property.

The Size property is used for binary and string types.

For nonstring data types and ANSI string data, the Size property refers to the number of bytes. For Unicode string data, Size refers to the number of characters. The count for strings does not include the terminating character.

For variable-length data types, Size describes the maximum amount of data to transmit to the server. For example, for a Unicode string value, Size 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 Size 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, Size does not contain inferred value after statement execution.

For fixed-length data types, the value of Size 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.


[Visual Basic, C#, C++] The following example creates an OracleParameter and sets some of its properties.

[Visual Basic] 
Public Sub CreateOracleParameter()
    Dim myParameter As New OracleParameter("pDescription", OracleType.VarChar)
    myParameter.IsNullable = True
    myParameter.Direction = ParameterDirection.Output
    myParameter.Size = 88
End Sub 'CreateOracleParameter

public void CreateOracleParameter() 
    OracleParameter myParameter = new OracleParameter("pDescription", OracleType.VarChar);
    myParameter.IsNullable = true;
    myParameter.Direction = ParameterDirection.Output;
    myParameter.Size = 88;

void CreateOracleParameter() 
    OracleParameter* myParameter = new OracleParameter(S"pDescription", OracleType::VarChar);
    myParameter->IsNullable = true;
    myParameter->Direction = ParameterDirection::Output;
    myParameter->Size = 88;

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.


Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

.NET Framework Security: 

See Also

OracleParameter Class | OracleParameter Members | System.Data.OracleClient Namespace