|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Using OraOLEDB to Manipulate LOBs, 2 of 5
OLE DB is an open specification for accessing various types of data from different stores in a uniform way. It uses a set of COM interfaces for accessing and manipulating different types of data. The interfaces are available from various database providers.
OLE DB introduces the concept of consumer - provider. A consumer is a client application that uses or 'consumes' an OLE DB interface. A provider is a component that exposes an OLE DB interface.
A typical provider can retrieve data from a particular data store and expose the data to a consumer in tabular form.
OraOLEDB is an OLE DB provider for Oracle. it offers high performance and efficient access to Oracle data including LOBs. It also allows updates to certain LOB types.
The following LOB types are supported by OraOLEDB:
Rowset is an OLE DB object that provides READ/WRITE capability to data obtained by executing an SQL SELECT statement or a stored procedure that returns a REF Cursor.
BFILEs can be part of the rowset but they are read-only.