OracleParameter.Offset Property

Gets or sets the offset to the Value property.

[Visual Basic]
Public Property Offset As Integer
[C#]
public int Offset {get; set;}
[C++]
public: __property int get_Offset();
public: __property void set_Offset(int);
[JScript]
public function get Offset() : int;
public function set Offset(int);

Property Value

The offset to the Value. The default is 0.

Remarks

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.

Example

[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("pDName", OracleType.VarChar)
    myParameter.IsNullable = True
    myParameter.Offset = 3
End Sub 'CreateOracleParameter

[C#] 
public void CreateOracleParameter() 
 {
    OracleParameter myParameter = new OracleParameter("pDName", OracleType.VarChar);
    myParameter.IsNullable = true;
    myParameter.Offset = 3;
 }

[C++] 
public:
void CreateOracleParameter() 
 {
    OracleParameter* myParameter = new OracleParameter(S"pDName", OracleType::VarChar);
    myParameter->IsNullable = true;
    myParameter->Offset = 3;
 }

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

Requirements

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: 

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code

See Also

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