This topic has not yet been rated - Rate this topic

OracleLob.BeginBatch Method ()

.NET Framework 2.0

Prevents server-side triggers from firing while performing multiple read operations.

Namespace: System.Data.OracleClient
Assembly: System.Data.OracleClient (in system.data.oracleclient.dll)

public void BeginBatch ()

public void BeginBatch ()

JScript

public function BeginBatch ()

Exceptions

Exception type	Condition
InvalidOperationException	The connection is closed.
ObjectDisposedException	The object was closed or disposed.
OracleException	An Oracle error has occurred.

Remarks

Opens the LOB in ReadOnly mode; therefore, the LOB can only be read from, not written to, until the corresponding call to EndBatch. To perform batch writes to the LOB, call BeginBatch with ReadWrite.

Calling BeginBatch more than one time within the same transaction currently throws the Oracle "ORA-22293: LOB already opened in the same transaction" error. In addition, if you obtain the LOB using another OracleDataReader, and the original caller has not called the EndBatch method, the same error is generated. Therefore, you must call the EndBatch method when you are finished using the OracleLob.

Platforms

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

Version Information

.NET Framework

Supported in: 2.0, 1.1

Reference

OracleLob Class
OracleLob Members
System.Data.OracleClient Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD