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 Procedures that Return Result Sets

Re: Stored Procedures that Return Result Sets

From: Matt White <mattheww_at_theexperience.com>
Date: Wed, 08 Sep 1999 04:31:41 GMT
Message-ID: <NElB3.614$oF4.100848@typhoon2.gnilink.net>


There are actually two ways:

  1. Via ODBC: Use the Ref Cursor as an output parameter and make it the last parameter in your p-list
  2. Via OLD-DB: Use the above or use a para,eter of type TABLE

    Either way and your golden...

Matt White
The Experience
www.TheExperience.com

Christian Carollo <ccarollo_at_viva.com> wrote in message news:7r434q$vj7$1_at_madmax.keyway.net...
> Is it possible for Oracle 8i to return result sets for select queries?
>
>
>
>
Received on Tue Sep 07 1999 - 23:31:41 CDT

Original text of this message

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