Re: REF CURSOR returns no rows

From: David Browne (meat_at_hotmail.com)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 09:46:18 -0600

"MW" <mwazir77_ns@hotmail.com> wrote in message
news:%23zXHQQDDEHA.3080@TK2MSFTNGP10.phx.gbl...
> I am using MS .NET Framework Data Provider for Oracle version 1.0.1012.0
> (System.Data.OracleClient.dll) and Oracle9i Enterprise Edition Release
> 9.2.0.4.0.
>
> Thank you for your response. Since my procedure was working for simpler
> SELECT statements, I built its complexity slowly testing the resultset in
> .NET each time. It seems to me that when I do a MAX from one of the lower
> tables, the resultset returns empty-handed. I have modifed my query to
> include a nested table and derive my MAX column from it and its working
now.
> Although I am not sure why it did not work before. It still puzzles me a
> great deal.
>
> I dont have an OracleRefCursor object available. Is this a part of the
Data
> Provider from Oracle?

Yes.
>Is there any website that can give me a comparitive
> chart between the two providers?

Not that I know of, but they are very very similar. ODP.NET gives you
access to more cool Oracle features like Array Binding, PL/SQL tables, and
Oracle XML. Plus it supports multiple ref cursors, and has better support
than the MS driver.

Go to http://otn.oracle.com/tech/windows/odpnet/index.html and get ODP.NET.
The install includes the 9i version of the Oracle Client, which is likely
where your error is occuring.

David

Relevant Pages

  • statement.executeUpdate(String sql) - not inserting results in correct order
    ... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... GRDPRODPWRMAX, GRDPRODPWRMIN," + ...
    (comp.lang.java.databases)
  • using ORACLE stored procedure in ASP.NET 2.0
    ... Anyone experienced building gridview in Oracle environment using stored ... Since the resultSet in SP is a REF CURSOR, I am not sure what Type I ... statementHandle, CommandBehavior behavior, ArrayList& ... DataTabledatatables, Int32 startRecord, Int32 maxRecords, String ...
    (microsoft.public.dotnet.framework.aspnet)
  • inserting data from resultset into oracle database - but not inserting in correct order
    ... I am trying to insert the values of a resultset into an oracle ... particular table in a SQL server database, ... and then inserting that data from resultset into an oracle ... The range of data selected from the SQL database, ...
    (comp.lang.java.databases)
  • Re: REF CURSOR returns no rows
    ... I am using MS .NET Framework Data Provider for Oracle version 1.0.1012.0 ... tables, the resultset returns empty-handed. ... Provider from Oracle? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: order by question
    ... Oracle does NOT guarantee any resultset is according to any ... suspicions your 'productive environment' is not so productive, ... valuable information for me. ...
    (comp.databases.oracle.misc)