Re: Stored Procedure/Package Returning Recordset to C# application.

LineVoltageHalogen wrote:
> Is a ref cursor in a stored procedure the only way to return a record
> set in Oracle 9i/10g?

If you mean result set, then yes. You can also use varrays to return an
object type of rows or scalar values, but this is generally less
efficient.

> 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.

That is correct, it is one of the many, many differences between the
two databases.

.

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: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ...
    (microsoft.public.dotnet.languages.csharp)
  • 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)