• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

What datatype to use to return a table/array/recordset from an Oracle SP to C++/C#/VB?

Experts:

I have a stored procedure that has an OUT parameter of type RECORD.

From the C# code, we need not to read that data coming back from the sp.

Must we use a REF CURSOR?  We want to return resultsets without maintaining a cursor.  Is there any other way to read the RECORD without maintaining a cursor (i.e., connection)?

Thank you,
Patricia
0
pdlarue
Asked:
pdlarue
1 Solution
 
lostcarparkCommented:
I did a fair bit of experimenting, an the only ways I managed to get working were to return a REF CURSOR or seperate OUT paramaters for each field. The REF CURSOR seems to be handiest because it can be connected to a DataReader on the .NET side.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now