Re: .NET & Oracle Ref Cursor

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bishoy Ghaly (bishoy_at_dev2dev.org)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 13:43:01 +0200

in .NET why dont you use standard OracleClient Connection and command and
DataAdapter to return a DataSet of the result rows ?

"devchick25" <anonymous@discussions.microsoft.com> wrote in message
news:0b5f01c4e3c7$8c91f7f0$a401280a@phx.gbl...
> Hi,
>
> I am creating a service that uses an Oracle backend. I
> need to use a stored procedure/package to return a
> resultset from Oracle. In other words, I cannot use a
> direct select in the .NET code. The resultset may be
> zero, one, or many rows. Therefore, I have looked into
> using something that Oracle refers to as a ref cursor.
>
> Is the ref cursor what I'm looking for?
>
> How does .NET return a stored procedure that uses a ref
> cursor? Is it a result set? Any explanation or examples
> would be greatly appreciated.
>
> Thank you!

Relevant Pages

  • .NET & Oracle Ref Cursor
    ... I am creating a service that uses an Oracle backend. ... resultset from Oracle. ... Is the ref cursor what I'm looking for? ...
    (microsoft.public.dotnet.faqs)
  • Re: Reporting with dynamic sql
    ... In Oracle you *don't* need temporary tables. ... What you need is a REF CURSOR. ... variable cur REF CURSOR ... Sybrand Bakker, Senior Oracle DBA ...
    (comp.databases.oracle.misc)
  • Re: newbie passing parameters from Web page to Stored Procedure
    ... I think it is in my First SQL statement. ... I'm using Oracle 9i. ... CREATE OR REPLACE PACKAGE pkgpending AS ... What you likely want to do is return a REF CURSOR. ...
    (comp.databases.oracle.server)
  • 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: passing in list of values in stored procedure
    ... modified the procedure here to use REF CURSOR - applicable in Oracle ... not just lists as is evident from this example. ... back to .net programs and jdbc programs. ...
    (comp.databases.oracle.server)