Skip to Main Content
Forums

Oracle Developer Tools for Visual Studio

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Common Language Runtime CLR for Oracle Database issue

User_9O7R7Oct 31 2020 — edited Mar 30 2021

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

Comments

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:
ODAC Downloads - Oracle Universal Installer (0 Bytes)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.

1 person found this helpful
1 - 1

Post Details

Added on Oct 31 2020
#oracle-developer-tools-for-visual-studio
1 comment
321 views