asp.net using oracle collection types

[efinney]

Hi,

Does anyone have an example using asp.net with an oracle database
specifically calling stored procedures that return collection types of a
user defined type or simple data type? What driver did you use? What
hurdles did you have to over come?

We are an oracle shop and just started writing .net/asp.net apps. I have
searched the oracle technet site and found lots of sample code for .net
such as getting ref cursors back from a procedure but not collection
types. I think the .net developers are using some third party driver
called "corlab" or something to that affect.

References to sample code or code sites is appreciated.

TIA
Eric

 

[Frans Bouma [C# MVP]]

Hi,

Does anyone have an example using asp.net with an oracle database
specifically calling stored procedures that return collection types of a
user defined type or simple data type? What driver did you use? What
hurdles did you have to over come?

We are an oracle shop and just started writing .net/asp.net apps. I have
searched the oracle technet site and found lots of sample code for .net
such as getting ref cursors back from a procedure but not collection
types. I think the .net developers are using some third party driver
called "corlab" or something to that affect.

UDT's are currently not supported in any .NET driver for Oracle. The
reason for this is that they're often written in Java, and the type
itself isn't usable in .NET.

FB

--