OracleParameter.Offset 属性


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

 property int Offset { int get(); void set(int value); };
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. 例如,若要在服务器上的列中插入10MB 的文本,用户可能会执行10个1MB 块的参数化插入,将每个迭代上的 Offset 的值切换为1MB。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.