Re: .NET & Oracle Ref Cursor

anonymous_at_discussions.microsoft.com
Date: 12/17/04

  • Next message: balu: "problem of notification over system tray" 
    Date: Fri, 17 Dec 2004 05:14:19 -0800

    We would like to store the sql statement outside of
    the .NET application. We were originally thinking that a
    stored procedure would be the best option (so that we
    wouldn't have to change the .NET code if we needed to only
    change the SQL statement).

    if we could use the ref cursor, I think that would be the
    best option for us. But I'm not sure about the efficiency
    and what I need to do in .NET to make this work. (I'm a
    newbie to .NET).

    >-----Original Message-----
    >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!
    >
    >
    >.
    >

  • Next message: balu: "problem of notification over system tray"

    Relevant Pages

    • 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)
    • .NET & Oracle Ref Cursor
      ... I'm creating a .NET service using an Oracle backend. ... stored procedure. ... ref cursor must be declared as part of a package. ...
      (microsoft.public.dotnet.faqs)
    • 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)
    • Insert using an Oracle stored procedure
      ... I'm using the following code to insert a new record into an Oracle ... conn.open connStr ... The stored procedure is similar to: ... What is wrong with my SQL statement? ...
      (microsoft.public.inetserver.asp.db)
    • Re: How do i fill datagrid w/ oracle ?
      ... personally - i would create a stored procedure on the oracle db itself. ... note * you have to use a ref cursor. ... i was amazed how much faster the select statments ran when processed from the Oracle side. ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
      (microsoft.public.dotnet.framework.adonet)