9.5 ODP.NET API for LOBs

Oracle Data Provider for .NET (ODP.NET) is an ADO.NET provider for the Oracle AI Database.

ODP.NET offers fast and reliable access to Oracle data and features from any .NET Core or .NET Framework application. ODP.NET also uses and inherits classes and interfaces available in the Microsoft .NET Class Library. The ODP.NET supports the following LOBs as native data types with .NET: BLOB, CLOB, NCLOB, and BFILE.

See Also:

• LOB Support
• Obtaining LOB Data

Table 9-7 ODP.NET methods in OracleClob and OracleBlob classes

Category	Function/Procedure	Description
Open/Close Operations	BeginChunkWrite	Opens a LOB
	EndChunkWrite	Closes a LOB
	IsInChunkWriteMode	Checks if a LOB is open
Read Operations	Length	Gets the length of the LOB
	OptimumChunkSize	Gets the optimum read/write size
	Value	Returns the entire LOB data as a string for CLOB and a byte array for BLOB
	Read	Reads data from the LOB starting at the specified offset
	Search	Returns the matching position of a pattern in a LOB using INSTR
Modify Operations	Write	Writes data to the LOB at a specified offset
	Erase	Erases part of a LOB, starting at a specified offset
	SetLength	Trims the LOB value to the specified shorter length
Operations involving multiple locators	Compare	Compares all or part of the value of two LOBs
	IsEqual	Checks if two LOBs point to the same LOB data
	Append	Appends a LOB value to another LOB, or append a byte array, string, or character array to an existing LOB
	CopyTo	Copies all or part of a LOB to another LOB
	Clone	Assigns LOB locator src to LOB locator dst