asp.net using oracle collection types

[efinney]

Hi,

Has anyone had any luck using asp.net with an oracle database
specifically calling stored procedures that return collection types of a
user defined type or simply a varchar2 data type? What driver did you
use? What hurdles did you have to over come?

References to sample code is be appreciated.

TIA
Eric

 

[Scott Allen]

Hi efinney:

You might try asking in the .adonet group if you don't see a response
here.

 

[John Timney \(ASP.NET MVP\)]

You can find examples at oracles site, and a driver to install on your
server with the client tools if you dont want to use the net oracle driver
that comes with .net 1.1. Not the most intuitive database tool to use with
asp.net though, and its a little wacky to get setup compared to ms
sql/msde/mysql or something as lite as access.

If you can, get the oracle devs in your compnay to create web service
interfaces to the data you want and forget about making calls directly,
instead proxying the web service methods to the oracle procs - not tried it
but I believe oracle 10 has this capability.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director