We’re sorry. We could not find a match for your search.

We suggest you try the following to help find what you’re looking for:

  • Check the spelling of your keyword search.
  • Use synonyms for the keyword you typed, for example, try "application" instead of "software."
  • Start a new search.
Cloud Account Sign in to Cloud
Oracle Account

Technical Comparison: ODP.NET Versus Microsoft OracleClient


Feature ODP.NET Microsoft OracleClient
Statement Caching Yes No
Fine Grain Contol Over Data Fetch Size Yes No
Parameter Array Binding Yes No
Performance Counters Yes Yes
Self-Tuning Yes No
Promotable Transactions Yes No
Local Transactions in System.Transactions Yes No
LOB pre-fetching Yes No
PL/SQL Associative Array Yes No
Bulk Copy Yes No


Feature ODP.NET Microsoft OracleClient
Proxy Authentication Yes No
Virtual Private Database Yes No
End to End Tracing Attributes Yes No

High Availability and Scalability

Oracle Database Technology

Feature ODP.NET Microsoft OracleClient
PL/SQL Support Yes Yes
REF CURSOR Type Yes Partial
Oracle Complex Types: XML , OBJECT, VARRAY, NESTED TABLE, REF Yes No
Client Result Cache Yes Yes
Database Change Notification Yes No
Advanced Queueing API Yes No

Ease of Use and Developer Productivity

ODP.NET for Microsoft OracleClient Developers Home