Re: Stored procs & result sets

From: David Russell <user_at_msn.com>
Date: 1998/01/01
Message-ID: <01bd16f5$70140240$706745c2@thor>#1/1

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 Thu Jan 01 1998 - 00:00:00 CST