Using oracle UDT for multiple insert in 12 c (12.1.0.2)

2961941

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

MateuszH

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#ODPNT7403

https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403

https://docs.oracle.com/database/121/ODPNT/featUDTs.htm#ODPNT390

m.

MateuszH

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#ODPNT7403

https://docs.oracle.com/database/121/ODPNT/OracleCustomTypeMappingAttributeClass.htm#ODPNT7403

https://docs.oracle.com/database/121/ODPNT/featUDTs.htm#ODPNT390

m.