Re: Stored Procedures / Oracle / ODBC

Todd Bleeker <todd_bleeker_at_ccmail.fingerhut.com> wrote:
>I believe that this is where Oracle and SQL*Server are very different.
>Oracle cannot return a rs from within a stored procedure like SQL*Server
>can. Oracle stored procedures are self contained and would typically be
>used to accomplish action tasks. The select statement would have to be
>coded in VB and the rs opened after the stored procedure completed.
>Frustrating, isn't it.
>
>So you have yourself both an ODBC limitation and an Oracle stored procedure
>limitation.

Is this true? Can Oracle not return a recordset of rows through ODBC? Please excuse the ignorant nature of this question. I am coming from a Sybase environment, and our development group is currently contemplating the consequences of converting to Oracle.

Please direct replies, flames, etc. through email and I will summarize if requested. Thanks.

-- 
Mark Deason					mailto:msd_at_sharpwa.com
Sr. CIM Engineer				Voice:	(360)834-8739
Sharp Microelectronics Technology, Inc.		FAX:	(360)817-7556
5700 NW Pacific Rim Blvd.
Camas, WA  98607