LobBlockSize Property

In This Topic

Specifies the size of a block (in megabytes) to read/write CLOB or NCLOB data from/to database. This option is supported in OCI mode only. Applicable only for Unicode Oracle servers.

Syntax

Visual Basic
C#

'Declaration
 
Public Property LobBlockSize As Integer

public int LobBlockSize {get; set;}

Property Value

The size of a block (in megabytes) to read/write CLOB or NCLOB data from/to database.

Remarks

Default value is 0, which means that the whole value is sent in one block. If you get errors when reading/writing huge LOB values, try setting this property to 8, it is the safest value.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleConnectionStringBuilder Class
OracleConnectionStringBuilder Members

Send Feedback