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

  • Thread starter Thread starter Frans Bouma
  • Start date Start date
F

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
 
Frans Bouma said:
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?
Click to expand...
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
 
David Browne said:
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.
Click to expand...

Ok thanks :)

FB
 
Back
Top