Oracle Database Extensions for .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 2010, Visual Studio 2008, and Visual Studio 2005.

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 a database option and is included with the Oracle Database on Windows installation. Further upgrades are installed as part of the Oracle Database Access Components (ODAC) releases, however the database option 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 Developer's Guide for more details.

The new 11.2.0.1.2 release below offers support for .NET stored procedures and functions that use the .NET Framework 4.

Download 32-bit ODAC 11.2.0.1.2 New support for .NET Framework 4!
Download 32-bit ODAC 11.1.0.7.20
Download 32-bit ODAC 11.1.0.6.20
Download 32-bit ODAC 10.2.0.2.21
Download 64-bit ODAC 10.2.0.3

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

Video:
View a demo showing how to develop and deploy a .NET stored procedure.

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