Re: asp.net using oracle collection types

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

efinney wrote: 
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

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
.

Relevant Pages

  • asp.net using oracle collection types
    ... We are an oracle shop and just started writing .net/asp.net apps. ... 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 ...
    (microsoft.public.dotnet.framework.adonet)
  • Calling stored procedures with JDBC
    ... I need to find good examples/tutorials for calling stored procedures (of ... oracle) with in/out parameters which can be recordsets/cursors etc. ... Meanwhile i'm searching google. ...
    (comp.lang.java.databases)