Common Language Runtime CLR for Oracle Database issue

User_9O7R7

Hi,

I need to develop a CLR for Oracle Database.

My configuration is:

Oracle 19

Visual Studio 2019 Enterprise Ed

Oracle Developer Tools for VS 2019 19.31.0.0

Oracle Developer Tools Visual Studio Help 19.31.0.0

I read "Extensions for .NET Developer's Guide for Microsoft" but I can't develop a working applications:

I don't have any Oracle project under Visual C# project on VS;

I don't have the "Oracle Deployment Wizard" in Build menu in VS,

Does anyone have a guide to making a CLR in Oracle environment?

Thank you very much,

Paolo

Christian.Shay -Oracle

Hi Paolo,

You posted this to the wrong forum, but I don't have the privileges to move it yet. It should go in "Oracle Developer Tools for Visual Studio".

You can't use Visual Studio 2019 to deploy code to the database for Oracle Database Extensions for .NET (eg CLR in the database). We will have a release that supports this by the end of the year.

What you will need to do is use Visual Studio 2017 and the 18.3 version of ODTwithODAC:

https://www.oracle.com/database/technologies/dotnet-odacdev-downloads.html

Before you install it, be sure to uninstall any ODT you have currently installed.

Also, I do not recommend you use the CLR feature unless absolutely necessary. It is much preferable to put your .NET code in the middle tier or elsewhere.