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

User_CXJFI

This would be incredibly helpful. Being able to pick a delimiter would solve the problem for me - it's a pain to process the CSV files right now as the data I'm querying seems to always strings with commas. Since I can't get the preview window to display all rows nor the size of the result set by default, I end up exporting every result set but have to do further processing in order to use it due to the comma limitations.

User_WRSVZ

+1 Being able to change the delimiter would be VERY helpful. Also being able to define the text identifier for the CSV would also be helpful.

Thanks all for the feedback about CSV delimiters. This is on our list of future features.

1 person found this helpful

Hi,
We just released version 19.3.4 which adds 2 settings for CSV delimiters and string encapsulation. Could you please try it out and let me know what you think?

Bjego
Answer

Looks good thank you!

Marked as Answer by Bjego · Mar 24 2021
1 - 5

Post Details

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