By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,365 Members | 1,245 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,365 IT Pros & Developers. It's quick & easy.

asp.net using oracle collection types

P: n/a
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
Nov 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi efinney:

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

--
Scott
http:// mud

On Tue, 12 Apr 2005 15:30:41 -0400, efinney <ef*****@mitre.org> wrote:
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


Nov 19 '05 #2

P: n/a
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

"Scott Allen" <sc***@nospam.odetocode.com> wrote in message
news:gq********************************@4ax.com...
Hi efinney:

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

--
Scott
http:// mud

On Tue, 12 Apr 2005 15:30:41 -0400, efinney <ef*****@mitre.org> wrote:
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

Nov 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.