.NET & Oracle Ref Cursor

From: devchick25 (tbrinkley_at_capgeminienergy.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 15:57:20 -0800

Hi,

I'm creating a .NET service using an Oracle backend. We
would prefer executing our select statements within a
stored procedure. One of our select statement will return
0, 1, or many records.

Is it possible to return a resultset from Oracle to .NET
using an Oracle ref cursor? It's my understanding that a
ref cursor must be declared as part of a package. The
package should also have a proc that references that ref
cursor.

Can someone explain how to return/call the stored
procedure/package from .NET and return a resultset. As
mentioned, the proc. in the package would need to use a
ref cursor (I believe).

Any insight would be appreciated.

Thanks!

Relevant Pages

  • Re: .NET & Oracle Ref Cursor
    ... change the SQL statement). ... >> I am creating a service that uses an Oracle backend. ... >> using something that Oracle refers to as a ref cursor. ... >> How does .NET return a stored procedure that uses a ref ...
    (microsoft.public.dotnet.faqs)
  • Re: Stored Procedure/Package Returning Recordset to C# application.
    ... wrote:>Is a ref cursor in a stored procedure the only way to return a record>set in Oracle 9i/10g? ... >In SQL Server you can simply put "select * from table" in a stored proc>and you are good to go. ... It appears that in Oracle you cannot do this. ...
    (comp.databases.oracle.server)
  • Re: Oracle with Crystal Reports 11.5.3
    ... Try using a ref cursor defined with a sys_refcursor definition.. ... return result of the stored procedure if my procedure is selecting ... multiple fields from multiple tables... ... procedures which are part of a package - it will find them initially ...
    (comp.databases.oracle.server)
  • Re: SQL Passthrough to Oracle..
    ... and can not handle a ref cursor being returned to VFP... ... DSN to use an Oracle driver and things are functioning better.. ... The package exist in my development schema.. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Stored Procedure/Package Returning Recordset to C# application.
    ... > Is a ref cursor in a stored procedure the only way to return a record ... It appears that in Oracle you cannot do this. ... two databases. ...
    (comp.databases.oracle.server)
Quantcast