- 3,716,133 Users
- 2,242,960 Discussions
- 7,845,840 Comments
Forum Stats
Discussions
Categories
- 17 Data
- 362.2K Big Data Appliance
- 7 Data Science
- 1.6K Databases
- 479 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
- 259 Java
- 6 Java Learning Subscription
- 11 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
- 31 Workshops
- 9 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 4 Deutsche Oracle Community
- 11 Español
- 1.9K Japanese
- 2 Portuguese
Using oracle UDT for multiple insert in 12 c (12.1.0.2)
Hi all,
I posted before regarding using oracle UDT stored procedure parameter type to pass a list of records for multiple insert using .net c#.
I had the below example where a class definition is needed at .net side to map to oracle object. Unfortunately I did not apply this due to the extra mapping code that is needed.
[url]http://appsjack.blogspot.com.eg/2010/09/pass-custom-udt-types-to-oracle-stored.html[/url]
My question is: did this change with oracle 12c? Can we now use:
parameter.UdtTypeName = directOracleUTDName; //without the need for .net definition and mapping calsses
Thanks,
Ferro
Best Answer
-
Hi,
I think yes, we still need uses a mapping.
"The
OracleCustomTypeMapping
attribute must be specified on the custom type factory class to indicate the Oracle UDT that the corresponding custom type represents. The Oracle UDT may be specified in the form<span class="codeinlineitalic" style="font-style: italic;">schema_name.type_name</span>
."
https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403
https://docs.oracle.com/database/121/ODPNT/featUDTs.htm#ODPNT390
m.
Answers
-
Hi,
I think yes, we still need uses a mapping.
"The
OracleCustomTypeMapping
attribute must be specified on the custom type factory class to indicate the Oracle UDT that the corresponding custom type represents. The Oracle UDT may be specified in the form<span class="codeinlineitalic" style="font-style: italic;">schema_name.type_name</span>
."
https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403
https://docs.oracle.com/database/121/ODPNT/featUDTs.htm#ODPNT390
m.