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

Posted on 2006-05-25
Last Modified: 2010-04-17

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,
Question by:pdlarue
    1 Comment
    LVL 5

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article will show, step by step, how to integrate R code into a R Sweave document
    Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now