Oracle Database Extensions for .NET

The Oracle Database Extensions for .NET is a feature of Oracle Database on Windows that makes it easy to develop, deploy, and run stored procedures and functions written in a .NET managed language such as C# or VB.NET.

.NET Stored procedures or functions are developed using Microsoft Visual Studio and deployed using the tightly integrated .NET Deployment Wizard which is a feature included in the Oracle Developer Tools for Visual Studio. You can develop and deploy your .NET stored procedures from Visual Studio 2013, Visual Studio 2012, and Visual Studio 2010.

After deploying, a .NET stored procedure can be called from within .NET application code, from SQL or PL/SQL, from another .NET, PL/SQL or Java stored procedure, from a trigger, or from anywhere else a stored procedure or function call is allowed.

This product is included with the Oracle Database on Windows installation. Further upgrades are installed as part of the Oracle Database Access Components (ODAC) releases, however Oracle Database Extensions for .NET must first be installed and configured before it can be upgraded.

Downloads:
Select the ODAC download corresponding to the version of your database. As of version 11.1.0.7.20, .NET 1.x based stored procedures are no longer supported and may require a non-trivial migration to .NET 2.x. Before upgrading to this version or higher, please read chapter 2 of the Oracle Database Extensions for .NET Developer's Guide for more details.

 Download 32-bit ODAC 
 Download 64-bit ODAC

Guided Walkthough:
 Oracle By Example: Developing and Deploying a .NET Stored Function

Read:
 Oracle Database Extensions for .NET Developer's Guide

 

Technical Information
 Using .NET Stored Procedures in Oracle (from the Mastering .NET Application Development series) Dec 2005
 Oracle OpenWorld 2005: Introducing .NET Stored Procedures for Oracle Database 10g Release 2 and Oracle Developer Tools for Visual Studio .NET (PPT) Sept 2005