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 _
)
[C#]
public void Append(
 OracleLob source
);
[C++]
public: void Append(
 OracleLob* source
);
[JScript]
public function Append(
   source : OracleLob
);

Parameters

source
The LOB from which to append data.

Exceptions

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

-or-

The connection is closed.

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

Remarks

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.

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: 

See Also

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

Show: