This documentation is archived and is not being maintained.

OracleLob.Append Method

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Appends data from the specified LOB to the current LOB.

[Visual Basic]
Public Sub Append( _
   ByVal source As OracleLob _
public void Append(
 OracleLob source
public: void Append(
 OracleLob* source
public function Append(
   source : OracleLob


The LOB from which to append data.


Exception Type Condition
ArgumentNullException The source OracleLob is null.
InvalidOperationException The source OracleLob is null.


The connection is closed.

ObjectDisposedException The source OracleLob object was closed or disposed.
OracleException An Oracle error has occurred.


To write to the LOB, you must have retrieved the LOB using the FOR UPDATE clause in the SQL SELECT statement, and you must have a local transaction started.

All data from the source LOB is appended to the end of the current LOB. The position of neither LOB is evaluated or changed during this process.

The underlying data types must always be the same. For example, if you are appending from an NClob, the destination OracleLob must also be an NClob.

Note   In this release, a write operation to a read-only LOB might succeed, but will not update the LOB on the server. In this case, however, the local copy of the LOB will be updated. Therefore, subsequent read operations on the OracleLob object might return the results of the write operation.


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: 

See Also

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