Changes in Releases for Oracle Database Extensions for .NET Developer's Guide

Changes in Oracle Database 21c Release 3 (21.3)

The following are changes in Oracle Database Extensions for .NET Developer's Guide for Oracle Database 21c Release 3 (21.3).

Deprecation of Oracle Database Extensions for .NET

Oracle Database Extensions for .NET is deprecated in Oracle Database 21c. Oracle recommends that you either place .NET code in the middle tier, or use the External Procedures feature, or rewrite the code using PL/SQL or Java.

Oracle Database Extensions for .NET is a feature of Oracle Database on Microsoft Windows that enables you to use stored procedures and functions written in a language managed by .NET, such as C#.

Oracle Database hosts the Microsoft Common Language Runtime (CLR) in an external process, outside of the Oracle Database process. Application developers can write stored procedures and functions using any .NET compliant language, such as C# and VB.NET, and use these .NET stored procedures in the database, in the same manner as other PL/SQL or Java stored procedures. .NET stored procedures can be called from PL/SQL packages, procedures, functions, and triggers; from SQL statements; or from anywhere a PL/SQL procedure or function can be called.

Migration options include:

Moving the .NET code (assemblies) into a middle tier
Using the External Procedures feature to have the external process load and execute the .NET assembly
Rewriting the stored procedures using PL/SQL or Java

Changes in Oracle Database 12c Release 2 (12.2)

The following are changes in Oracle Database Extensions for .NET Developer's Guide for Oracle Database 12c Release 2 (12.2).

New Features

The following features are new in this release:

Unhandled exceptions are no longer automatically handled.

Beginning with this release of Oracle Database Extensions for .NET, unhandled exceptions in .NET stored procedures or functions will terminate the process to make it easier to detect issues as soon as it happens. This behavior can be modified through the extproc.exe.config configuration file.

See Also:

extproc.exe.config Configuration File
Oracle assemblies are no longer placed in Global Assembly Cache

The Oracle Database Extensions for .NET no longer places its assemblies in the Global Assembly Cache (GAC). The extproc.exe.config configuration file is configured properly by the installer with the location of these assemblies so that they can be located and loaded at runtime.

See Also:

extproc.exe.config Configuration File
New TraceFileLocation registry key

The TraceFileLocation registry key allows you to choose the directory in which the trace files will be generated.

See Also:

TraceFileLocation

Changes in Oracle Database 12c Release 1 (12.1)

The following are changes in Oracle Database Extensions for .NET Developer's Guide for Oracle Database 12c Release 1 (12.1).

New Features

The following features are new in this release:

The Oracle CLR services now runs as the Oracle Home User, a potentially lower privileged user that is defined during database installation. These services are no longer automatically created by the installer. Instead, a new utility, OraClrCtl.exe, is used to create them.

See Also:

"Oracle CLR Services and the Oracle Home User Account."