Ask Learn
Preview
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
CopyTo(OracleLob) | |
CopyTo(OracleLob, Int64) |
Copies from this OracleLob to a destination OracleLob with the specified amount of data. |
CopyTo(Int64, OracleLob, Int64, Int64) |
Copies from this OracleLob to a destination OracleLob with the specified amount of data, and the source offset. |
public:
long CopyTo(System::Data::OracleClient::OracleLob ^ destination);
public long CopyTo(System.Data.OracleClient.OracleLob destination);
member this.CopyTo : System.Data.OracleClient.OracleLob -> int64
override this.CopyTo : System.Data.OracleClient.OracleLob -> int64
Public Function CopyTo (destination As OracleLob) As Long
The number of bytes copied. This excludes any padded bytes.
The OracleLob specified in the destination
parameter is null.
The operation is not within a transaction, the OracleLob object is null, or the connection is closed.
An Oracle error has occurred.
The underlying data types must always be the same. For example, if you are copying from an NClob, the destination OracleLob must also be an NClob.
If the destination offset is beyond the end of destination LOB
, the LOB
to which the data is being copied is extended. The space between the end of the LOB
and the destination offset beyond the end is padded with zeros for BLOB
data types and spaces for CLOB
and NCLOB
data types.
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.
Note
In this release, a write operation to a read-only LOB
might succeed, but not update the LOB
on the server. In this case, however, the local copy of the LOB
will be updated. Therefore, later read operations on the OracleLob object might return the results of the write operation.
The CopyTo
method does not clear the contents of the destination OracleLob
before performing the copy operation.
Product | Versions |
---|---|
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
public:
long CopyTo(System::Data::OracleClient::OracleLob ^ destination, long destinationOffset);
public long CopyTo(System.Data.OracleClient.OracleLob destination, long destinationOffset);
member this.CopyTo : System.Data.OracleClient.OracleLob * int64 -> int64
override this.CopyTo : System.Data.OracleClient.OracleLob * int64 -> int64
Public Function CopyTo (destination As OracleLob, destinationOffset As Long) As Long
The offset to which to copy. For CLOB
and NCLOB
data types, this must be an even number of bytes.
The number of bytes copied. This excludes any padded bytes.
The OracleLob specified in the destination
parameter is full.
A value specified in the destinationOffset
parameter is less than zero or greater than 4 gigabytes.
-or-
A value specified in the destinationOffset
parameter for a CLOB
or NCLOB
data type is not even.
-or-
You must specify CLOB
and NCLOB
data types as an even number of bytes.
The operation is not within a transaction, the OracleLob object is null, or the connection is closed.
An Oracle error has occurred.
The underlying data types must always be the same. For example, if you are copying from an NClob, the destination OracleLob must also be an NClob.
If the destination offset is beyond the end of destination LOB
, the LOB
to which the data is being copied is extended. The space between the end of LOB
and destination offset beyond the end is padded with zeros for BLOB
data types and spaces for CLOB
and NCLOB
data types.
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.
Note
In this release, a write operation to a read-only LOB
might succeed, but does not update the LOB
on the server. In this case, however, the local copy of the LOB
is updated. Therefore, later read operations on the OracleLob object might return the results of the write operation.
The CopyTo
method does not clear the contents of the destination OracleLob
before performing the copy operation.
Product | Versions |
---|---|
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
public:
long CopyTo(long sourceOffset, System::Data::OracleClient::OracleLob ^ destination, long destinationOffset, long amount);
public long CopyTo(long sourceOffset, System.Data.OracleClient.OracleLob destination, long destinationOffset, long amount);
member this.CopyTo : int64 * System.Data.OracleClient.OracleLob * int64 * int64 -> int64
override this.CopyTo : int64 * System.Data.OracleClient.OracleLob * int64 * int64 -> int64
Public Function CopyTo (sourceOffset As Long, destination As OracleLob, destinationOffset As Long, amount As Long) As Long
The offset from which to copy. For CLOB
and NCLOB
data types, this must be an even number.
The destination OracleLob
System.Data.OracleClient.
The destination offset to which to copy. For CLOB
and NCLOB
data types, this must be an even number.
The quantity of data, in bytes, to copy. For CLOB
and NCLOB
data types, this must be an even number.
The number of bytes copied. This excludes any padded bytes.
The OracleLob specified in the destination
parameter is full.
A value specified in the amount
, sourceOffset
, or destinationOffset
parameter is less than zero or greater than 4 gigabytes.
-or-
A value specified in the amount
, sourceOffset
, or destinationOffset
parameter for a CLOB
or NCLOB
data type is not even.
The operation is not within a transaction, the OracleLob object is null, or the connection is closed.
An Oracle error has occurred.
The underlying data types must always be the same. For example, if you are copying from an NClob, the destination OracleLob must also be an NClob.
If the destination offset is beyond the end of destination LOB
, the LOB
to which the data is being copied is extended. The space between the end of LOB
and destination offset beyond the end is padded with zeros for BLOB
data types and spaces for CLOB
and NCLOB
data types.
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.
Note
In this release, a write operation to a read-only LOB
might succeed, but does not update the LOB
on the server. In this case, however, the local copy of the LOB
is updated. Therefore, later read operations on the OracleLob object might return the results of the write operation.
The CopyTo
method does not clear the contents of the destination OracleLob
before performing the copy operation.
Product | Versions |
---|---|
.NET Framework | 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, 4.5.1, 4.5.2, 4.6, 4.6.1, 4.6.2, 4.7, 4.7.1, 4.7.2, 4.8, 4.8.1 |
.NET feedback
.NET is an open source project. Select a link to provide feedback:
Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.
Please sign in to use Ask Learn.
Sign in