Where in the world is "OracleDbType.Object"? — oracle-tech

    Forum Stats

  • 3,715,657 Users
  • 2,242,821 Discussions
  • 7,845,481 Comments

Discussions

Howdy, Stranger!

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

Where in the world is "OracleDbType.Object"?

JWu
JWu Member Posts: 8 Red Ribbon
edited February 2020 in ODP.NET

All of the tutorial style article online about programming user-defined type are setting OracleDbType to OracleDbType.Object.

However, this is apparently not supported in the latest ManagedDataAccess.  No one seems to know for sure what's Oracle's new direction with OracleDbType in the "what changed" documentation.

Does anyone know?

A rather frustrated developer....

JWu

Best Answer

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited February 2020 Accepted Answer

    Managed ODP.NET does not support UDTs. Only unmanaged ODP.NET supports UDTs at this time. Managed ODP.NET was first released with 12c.

    The ODP.NET dev team is working on porting UDT functionality to managed ODP.NET. It's a very large project. We'll be able to provide a timeline for delivery after making some more progress.

    If you would like to use UDTs today, use unmanaged ODP.NET for your project instead.

    JWuJWu

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,751 Employee
    edited February 2020 Accepted Answer

    Managed ODP.NET does not support UDTs. Only unmanaged ODP.NET supports UDTs at this time. Managed ODP.NET was first released with 12c.

    The ODP.NET dev team is working on porting UDT functionality to managed ODP.NET. It's a very large project. We'll be able to provide a timeline for delivery after making some more progress.

    If you would like to use UDTs today, use unmanaged ODP.NET for your project instead.

    JWuJWu
Sign In or Register to comment.