- 3,715,657 Users
- 2,242,821 Discussions
- 7,845,481 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 467 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 487 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 416 SQLcl
- 42 SQL Developer Data Modeler
- 184.8K SQL & PL/SQL
- 21K SQL Developer
- 1.9K Development
- 3 Developer Projects
- 32 Programming Languages
- 135.1K Development Tools
- 8 DevOps
- 3K QA/Testing
- 247 Java
- 5 Java Learning Subscription
- 10 Database Connectivity
- 66 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
- 10 Español
- 1.9K Japanese
- 2 Portuguese
Where in the world is "OracleDbType.Object"?
All of the tutorial style article online about programming user-defined type are setting OracleDbType to OracleDbType.Object.
However, this is apparently not supported in the latest ManagedDataAccess. No one seems to know for sure what's Oracle's new direction with OracleDbType in the "what changed" documentation.
Does anyone know?
A rather frustrated developer....
Best Answer
-
Managed ODP.NET does not support UDTs. Only unmanaged ODP.NET supports UDTs at this time. Managed ODP.NET was first released with 12c.
The ODP.NET dev team is working on porting UDT functionality to managed ODP.NET. It's a very large project. We'll be able to provide a timeline for delivery after making some more progress.
If you would like to use UDTs today, use unmanaged ODP.NET for your project instead.
Answers
-
Managed ODP.NET does not support UDTs. Only unmanaged ODP.NET supports UDTs at this time. Managed ODP.NET was first released with 12c.
The ODP.NET dev team is working on porting UDT functionality to managed ODP.NET. It's a very large project. We'll be able to provide a timeline for delivery after making some more progress.
If you would like to use UDTs today, use unmanaged ODP.NET for your project instead.