OracleLob.Append Method
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:
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code
See Also
OracleLob Class | OracleLob Members | System.Data.OracleClient Namespace
