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: jason <jfielding_at_trinitech.co.uk>
Date: Wed, 8 Sep 1999 09:28:16 +0100
Message-ID: <7r56mv$ge$1@trinitech.demon.co.uk>


I'm using the TABLE method and calling this using ADO 2.1 from a VB6 app, but if I try returning more than 4 params, I get : "at 0xXXXXXXXX referenced memory at 0xXXXXXXXX. The memory could not be written. "
Does anyone know of a sollution ?
TIA
Jason

Matt White wrote in message ...
>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 Wed Sep 08 1999 - 03:28:16 CDT

Original text of this message

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