Common Language Runtime CLR for Oracle Database issue — oracle-tech

    Forum Stats

  • 3,715,959 Users
  • 2,242,917 Discussions
  • 7,845,703 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Common Language Runtime CLR for Oracle Database issue

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

Answers

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,786 Employee

    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:

    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.

    User_9O7R7
Sign In or Register to comment.