Oracle .NET driver / ODP.NET: how to deal with user defined types?

[Frans Bouma]

Hi,

I discovered I can't work with user defined types (like defined in the OE
example schema in Oracle) when I use the .NET 1.1 Oracle .NET provider from
Microsoft. I switched to ODP.NET, also for the LOB support, but can't find
anything about how to deal with user defined types as well. Is this possible
from .NET or should I simply forget to deal with Oracle's user defined types
from .NET for now?

TIA

Frans

 

[David Browne]

Hi,

I discovered I can't work with user defined types (like defined in the OE
example schema in Oracle) when I use the .NET 1.1 Oracle .NET provider from
Microsoft. I switched to ODP.NET, also for the LOB support, but can't find
anything about how to deal with user defined types as well. Is this possible
from .NET or should I simply forget to deal with Oracle's user defined types
from .NET for now?

For now, yes you cannot use row types or object types directly from .NET.
You can access them through PL/SQL wrappers which use standard scalar types,
PL/SQL Associative arrays, XML types, etc.

David

 

[Frans Bouma]

For now, yes you cannot use row types or object types directly from
.NET. You can access them through PL/SQL wrappers which use standard
scalar types, PL/SQL Associative arrays, XML types, etc.

Ok thanks

FB