OracleParameter.Offset OracleParameter.Offset OracleParameter.Offset OracleParameter.Offset Property

定义

获取或设置 Value 属性的偏移量。Gets or sets the offset to the Value property.

public:
 property int Offset { int get(); void set(int value); };
[System.ComponentModel.Browsable(false)]
public int Offset { get; set; }
member this.Offset : int with get, set
Public Property Offset As Integer

属性值

Value 的偏移量。The offset to the Value. 默认值为 0。The default is 0.

示例

下面的示例创建OracleParameter和设置的某些属性。The following example creates a OracleParameter and sets some of its properties.

Public Sub CreateOracleParameter()  
   Dim parameter As New OracleParameter("pDName", OracleType.VarChar)  
   parameter.IsNullable = True  
   parameter.Offset = 3  
End Sub  
public void CreateOracleParameter()   
{  
   OracleParameter parameter = new OracleParameter("pDName", OracleType.VarChar);  
   parameter.IsNullable = true;  
   parameter.Offset = 3;  
}  

注解

Offset属性用于二进制和字符串数据区块化客户端。The Offset property is used for client-side chunking of binary and string data. 例如,若要在服务器上的列中插入文本的 10 MB,用户可能会执行的 1 MB 数据块的 10 个参数化的插入移动的值Offset1 MB 的每次迭代。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 指定的二进制类型的字节数和的字符串的字符数。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.

适用于