These are the source examples that accompany the article "Optimize Oracle Data Access". they require Visual Studio 2003 and .NET 1.1 to run, although they are backward compatible to .NET 1.0.

To run, first sign on through SQL*Plus as the Oracle sample user SCOTT and run the code in sproc.sql to catalog the packages. Then run the program code. Before compiling the program code, replace the Data Source in the OracleConnection connection string with the name of your Oracle database.

The file zmv44_ora_3968.trc contains the output from an Oracle trace that proves multiple parameter sets require only one DBMS roundtrip. This file must be read with notepad; formatting with TKPROF will lose the parameter information.