RE: Retrieving multiple rows from an Oracle Stored Procedure/Function

Hi Ron,

Have you looked at the following articles (Basically the same article, one for C# the other VBNet)

309361 HOW TO: Use a DataReader Against an Oracle Stored Procedure in Visual C#
http://support.microsoft.com/?id=309361

308073 HOW TO: Use a DataReader Against an Oracle Stored Procedure in Visual
http://support.microsoft.com/?id=308073

These is the only information available here on this topic.

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : scotr@online.microsoft.com <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.

Get Secure!
http://www.microsoft.com/security
http://www.microsoft.com/protect


--------------------
>Thread-Topic: Retrieving multiple rows from an Oracle Stored Procedure/Function
>thread-index: AcPhzZtfP+GdFfVuRF+F8AakLKKfCw==
>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>From: =?Utf-8?B?Um9u?= <architect@topco.com>
>Subject: Retrieving multiple rows from an Oracle Stored Procedure/Function
>Date: Fri, 23 Jan 2004 08:26:08 -0800
>Lines: 7
>Message-ID: <C719AD07-FB49-4D45-9E69-13F6CEFF4E6A@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.dotnet.framework.adonet
>Path: cpmsftngxa07.phx.gbl
>Xref: cpmsftngxa07.phx.gbl microsoft.public.dotnet.framework.adonet:72477
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
>
>Hi



does anyone have information on what is required to retrieve multiple rows from an Oracle Stored Procedure (or Function) using
ADO.NET? Not only how to write VB.NET code to call the stored proc and dig out the data, but also how to write the Oracle procedure
itself. For example, is it better to use an OUT parameter in a Procedure versus a return value from a Function? Also, how does the output
have to be set up, using VARRAYs, etc



Sample code would be great but even links to articles would be helpful. Thanks in advance



-- Ron
>