Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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?
> 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.
Correct me if I'm wrong, but from what I understand SQL Server constructs and returns a ref cursor when you do not specify one in your procedure. Oracle requires you to code it explicitly but otherwise does exactly the same thing. Received on Mon Feb 06 2006 - 04:56:13 CST