dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnectionStringBuilder Class / LobBlockSize Property

In This Topic
    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
    '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

    See Also