- 3,715,959 Users
- 2,242,917 Discussions
- 7,845,703 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 475 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 5 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 417 SQLcl
- 42 SQL Developer Data Modeler
- 184.9K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 9 DevOps
- 3K QA/Testing
- 256 Java
- 6 Java Learning Subscription
- 10 Database Connectivity
- 67 Java Community Process
- 1 Java 25
- 9 Java APIs
- 141.1K Java Development Tools
- 6 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 135 Java 8 Questions
- 86.2K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 10 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 125 LiveLabs
- 30 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
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
-
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.