1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

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

Discussion in 'SQL PL/SQL' started by Ferro, Jan 30, 2018.

  1. Ferro

    Ferro Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    ME
    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.

    http://appsjack.blogspot.com.eg/2010/09/pass-custom-udt-types-to-oracle-stored.html

    My question is: did this change with oracle 12c? Can we now use:

    parameter.UdtTypeName = directOracleUDTName; //without the need for .net definition and mapping calsses

    Thanks,

    Ferro