Re: Stored procs & result sets

On Thu, 01 Jan 1998 12:40:00 -0800, "David Russell" <user_at_msn.com> wrote:

>No Oracle8 does no more than Oracle7.
>
>Both Oracle 7 and 8 can return PL/SQL tables of records, but your client
>side application has to be able to read them, many 3rd party tools are
>starting to support PL/SQL tables, but ODBC is unable to retrieve them. If
>you are writing your own applications in Pro*C++, OCI or Object for OLE
>then this interface if fully exposed.
>
>It looks very unlikly that Oracle 8.1+ will support RETURNING results of
>records because of ANSI restrictions and the existing mechanism is
>available.
>--
>
>Regards
>David Russell
>
>jon glickman <jglickma_at_lynx.dac.neu.edu> wrote in article
><68bcrl$2ba$1_at_isn.dac.neu.edu>...
>> Does Oracle return result sets from a stored proc yet
>> in version 8.
>>

We are using Oracle Object for OLE and are able to return result sets from a 7.3 database to a VB5 application. In fact, with the newest version of OO4O we are returning multiple results sets from a single procedure call.

I would assume this is also available with OCI calls, but have never actually tried it.

--
Mark Wagoner
To reply, remove no.spam from my e-mail address