Skip to Main Content
Forums

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!

ODP UDT Future on .NET core

4285382Jul 14 2020 — edited Jul 15 2020

Hello,

We are migrating a high profile .NET web app to .NET core. We are on Oracle(12c) EBS.  All I/O is via stored procs with UDT parms.  There are 100's of nested UDTs.

According to a scattering of info on here, twitter, & https://github.com/oracle/dotnet-db-samples/issues/56  UDTs are not yet available for the managed .NET ODP for .NET Core.

  1. What is the potential availability of this (earliest and latest estimates)?
  2. What advice do you have for migrating to .NET Core while continuing to use UDTs? 
    1. Would this work:
      1. Continue (temporarily) to use existing .NET 4 services project that retrieves UDTs via current unmanaged ODP.  (so no change)
      2. Build new .NET web project on .NET Core.
      3. Build new .NET class library project using .NET Standard.  Migrate UDT classes from the .NET 4 services proj and make them POCO's (so trip out all the Oracle-specific references that wont work of course on .NET Standard).  Then in the .NET 4 services proj, manually pass the UDT classes to the POCO's, where the POCO's will also be reference/available in .NET Core.

Thanks! Any advice would be appreciated!
This post has been answered by Alex Keh-Oracle on Jul 14 2020
Jump to Answer

Comments

388131
First of all I would reconsider if you really need to create a trigger inside a procedure. Question the reason...
Then, if you really need to do create it that way, you could try dynamic sql.
Ludock
This trigger have to be on all tables.

After creation a table, i call the procedure to generate the trigger.
388131
Well, then proceed with dynamic SQL.

Or, in my opinion much better: produce a SQL script with variables for table name and trigger name.
Then run this script with the appropriate values every time you have created a table.

Cheers,
Guido

Edited by: Guido on Oct 22, 2008 10:30 AM
1 - 3

Post Details

Added on Jul 14 2020
#odp-net
3 comments
391 views