Skip to Main Content

ODP.NET

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!

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

User_UBS7MJan 29 2018 — edited Mar 13 2018

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

This post has been answered by MateuszH on Mar 13 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 10 2018
Added on Jan 29 2018
1 comment
580 views