Re: Stored Proc Question

Thomas Kyte <tkyte_at_us.oracle.com> wrote in article
> >I think you're missing the point Tim. In SQL-Server a stored proc can
> >contain a single SELECT statement
>
> With 7.2 and 7.3 of the database you have cursor variables. Cursor
> variables are cursors opened by a pl/sql routine and fetched from by
> another application or pl/sql routine (in 7.3 pl/sql routines can fetch
> from cursor variables as well as open them).
<snip>

Yeah, but unfortunately cursor variables to my knowledge is not supported in the ODBC 2.x API specification (maybe it's been included in the 3.x API spec?). Which of course makes using Oracle stored procs to return data to an ODBC application quite difficult.

> I've been told that the NEON ODBC adapter for Oracle supports cursor
> variables. Contact info can be found at http://internet1.neonsys.com/
>
> Also, The beta version of Microsoft's latest Oracle ODBC driver (v2.0) is
> available at: http://www.microsoft.com/msdownload/rds/rdsdownload.htm.

Thanx for the info. I will definately take a look at these drivers. But it's a pity that Oracle's ODBC driver does not support it. And it's a pity about the bugs in the driver too... <wink wink, nudge nudge> ;-)

regards,
Billy Received on Mon Oct 06 1997 - 00:00:00 CDT