Re: Stored procs & result sets

Not sure why you are saying ODBC is unable to retrieve pl*sql table as result sets. RDO and VB5 using Microsoft ODBC drivers for Oracle database can do it.

David Russell 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.
> >
> >
> >
  Received on Fri Jan 02 1998 - 00:00:00 CST