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

From: <mjbox01_at_gmail.com>
Date: 1 Feb 2006 11:04:46 -0800
Message-ID: <1138820686.422665.276660@g49g2000cwa.googlegroups.com>

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. Received on Wed Feb 01 2006 - 13:04:46 CST