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

Nov 19 '05 #1

Subscribe Reply

1445

Scott Allen

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

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

"Scott Allen" <sc***@nospam.o detocode.com> wrote in message
news:gq******** *************** *********@4ax.c om...

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

Similar topics

10739

Oracle Stored Procedures VERSUS SQL Server Stored Procedures

by: jrefactors | last post by:

I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures execute in the database server with better performance? Please advise good references for Oracle stored procedures also. thanks!!

Microsoft SQL Server

1818

migration toolkit (from oracle 9.x to udb 8.2.2)

by: _link98 | last post by:

Does IBM publish a complete list of features (of Oracle) which the IBM migration toolkit does *not* convert? The docs seem rather vague. For example: 1. What support for the oracle object-relational features (objects and member procedures etc). 2. any support for removing substitutable parameters in DDL (in sqlplus scripts) like "&&1"....

DB2 Database

17032

Oracle vs Access

by: Rosco | last post by:

Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.

Microsoft Access / VBA

2974

Confused about using Reflection to examine a collection

by: Robert W. | last post by:

I'm trying to write a utility that will use Reflection to examine any data model I pass it and correctly map out this model into a tree structure. When I say "any" , in fact there will only be 3 types of items in the very hierarchical data model: - Classes (and nested classes) - Collections - Properties I've successfully written the...

C# / C Sharp

13391

Returning a Collection object from .NET to VB6 (using COM Interop)

by: Scott M. Lyon | last post by:

As I mentioned in my other post, I'm attempting to, using COM Interop so I can update existing VB6 code to (for several specific functions) return a Hashtable from a .NET library. I've had very little luck processing the Hashtable itself in VB6 (I can add a reference to the project so it knows what a Hashtable is, but I'm not having much...

Visual Basic .NET

4912

Moigration from Oracle 10g to Db2 8.2

by: Ashish Patankar | last post by:

I want to migrate my Oracle 10g database to Db2. I want some documentation for the comparision between these to databases. I also want to know which features of Oracle 10g are supported by Db2 and which are not supported.

DB2 Database

3195

Problem with Oracle selecting object types

by: sam.lumbroso | last post by:

I have the following object type created in Oracle (OCI8): create or replace type address as object ( address VARCHAR2(80), city VARCHAR2(80), state VARCHAR2(20), zip VARCHAR2(10) )

PHP

3253

How to Initialize Collection Types/Object Types in Oracle

by: prasannakhapli | last post by:

Can Anybody help? How to Initialize Collection Types/Object Types in Oracle . can anybodu plese pass me on an Example on each?? thanks in Advance..

Oracle Database

3257

How to pass Collection Types(Table of Object) present in Oracle Procedure.

by: prasannakhapli | last post by:

Hi All, I need to invoke a Procedure containing Oracle Collection Types as IN Parameters in a PL/SQL Block. How can I do that. The Procedure that Iwant to invoke is : PROCEDURE createFault( reportedBy IN varchar2,

Oracle Database

8205

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8339

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7967

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

8220

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6619

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5392

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3872

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2347

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1185

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General