Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Offset Property

OracleParameter.Offset Property

Gets or sets the offset to the Value property.

Namespace:  System.Data.OracleClient
Assembly:  System.Data.OracleClient (in System.Data.OracleClient.dll)

[BrowsableAttribute(false)]
public int Offset { get; set; }

Property Value

Type: System.Int32
The offset to the Value. The default is 0.

The Offset property is used for client-side chunking of binary and string data. For example, in order to insert 10MB of text into a column on a server, a user might execute 10 parameterized inserts of 1MB chunks, shifting the value of Offset on each iteration by 1MB.

Offset specifies the number of bytes for binary types, and the number of characters for strings. The count for strings does not include the terminating character.

The following example creates a OracleParameter and sets some of its properties.

public void CreateOracleParameter() 
{
   OracleParameter parameter = new OracleParameter("pDName", OracleType.VarChar);
   parameter.IsNullable = true;
   parameter.Offset = 3;
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0, 1.1
Show:
© 2015 Microsoft