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

    Forum Stats

  • 3,716,133 Users
  • 2,242,960 Discussions
  • 7,845,840 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

2961941
2961941 Member Posts: 16
edited March 2018 in ODP.NET

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

Answers

This discussion has been closed.