Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Procedure/Package Returning Recordset to C# application.

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

From: William Robertson <william.robertson_at_bigfoot.com>
Date: 6 Feb 2006 02:56:13 -0800
Message-ID: <1139223373.881492.187810@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US