The page provides samples in C#, VB and VC++ that demonstrate various features of Oracle Provider for OLEDB 8.1x.

Database Setup [13-Mar-2003]
This file contains information about the database setup required for the all the Oracle OLEDB Samples below.
Download (ZIP, 97KB)

Visual Basic Samples

Chunk size sample [13-Mar-2003]
This sample demonstrates the use of ADO ChunkSize property versus ADO Value Property.
Download Now (ZIP, 37KB)

Date Format Sample[13-Mar-2003]
This sample shows how to use the date column in database table using Oracle OLEDB with ActiveX Data Objects (ADO).
Download Now (ZIP, 34KB)

Deferred Update for scalar data sample [13-Mar-2003]
This sample demonstrates the deferred update for scalar data feature of Oracle provider for OLEDB.  
Download Now (ZIP, 34KB)

Immediate update for non-scalar data [13-Mar-2003]
This sample demonstrates the deferred update for non-scalar data (LOB data) like images, sounds etc feature of Oracle provider for OLEDB.
Download Now (ZIP, 65KB)

Passing LOB parameters from and to a stored procedure [13-Mar-2003]
This sample demonstrates how to pass LOB parameters to and from a database stored procedure using Oracle OLEDB provider.
Download Now (ZIP, 84KB)

Returning multiple recordsets from a stored procedure[13-Mar-2003]
This sample shows how to return multiple recordsets from database stored procedure using ActiveX Data Objects (ADO) with VB
Download Now (ZIP, 103KB)

Passing Ndatatype to a Stored procedure [13-Mar-2003]
This sample demonstrates how to pass NDatatype parameters to a database stored procedure using Oracle OLEDB provider.
Download Now (ZIP, 75KB)

Fetch size and cache size [13-Mar-2003]
This sample aims at demonstrating the use of ADO FetchSize and CacheSize
Download Now (ZIP, 6KB)

VC++ ADO Samples

Returning Multiple recordsets and passing NLS data to a stored procedure using ADO with VC++ [13-Mar-2003]
This sample shows how to return multiple recordsets from an Oracle stored procedure and pass NVARCHAR2 parameters to the stored procedure using ActiveX Data Objects (ADO) with VC++.
Download Now (ZIP, 98KB)

Passing LOB parameters from and to a stored procedure using ADO with VC++ [13-Mar-2003]
This sample shows how to pass LOB parameters to and from an Oracle stored procedure using Oracle Provider for OLEDB and ActiveX Data Objects (ADO) with VC++.
Download Now (ZIP, 94KB)

VC++ OLEDB Samples

Returning Multiple recordsets and passing NLS data to a stored procedure using OLEDB Interfaces with VC++ [13-Mar-2003]
This sample shows how to return multiple recordsets from an Oracle stored procedure and pass NVARCHAR2 parameters to the stored procedure using OLEDB Interfaces with VC++.
Download Now (ZIP, 98KB)

Passing LOB parameters from and to a stored procedure using OLEDB Interfaces with VC++ [13-Mar-2003]
This sample shows how to pass LOB parameters to and from an Oracle stored procedure using Oracle Provider for OLEDB and OLEDB Interfaces with VC++.
Download Now (ZIP, 94KB)

C # Samples

Returning Multiple recordsets and passing NLS data to a stored procedure with C#[13-Mar-2003]
This sample shows how to return multiple recordsets from an Oracle stored procedure and pass NVARCHAR2 parameters to the stored procedure using ActiveX Data Objects (ADO) with Visual C Sharp.
Download Now (ZIP, 80KB)

Passing LOB parameters from and to a stored procedure using ADO with C # [13-Mar-2003]
This sample shows how to pass LOB parameters to and from an Oracle stored procedure using Oracle Provider for OLEDB and ActiveX Data Objects (ADO) with Visual C Sharp.
Download Now (ZIP, 84KB)