Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stored procs & result sets

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US