Re: Stored procedures

On 19 Mar 1998 21:18:21 GMT, "Andrew Barnett" <nobody_at_spamandeggs.bp.com> wrote: Hi,

use Oracle Objects for OLE, which are shipped with the client. Good samples (scott-schema) to illustrate use of pramarrays to handle PL/SQL-Tables. I'm just running a request at oracle support how to handle non-scalar tables.

>can you please give details of drivers etc for VB that cope with PL/SQL
>tables
>
>ta,
>--
>Andrew - Wizzard
>
>barnetaj_at_bp.com
>
>Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk> wrote in article
><890302962.5372.0.nnrp-04.c2de712e_at_news.demon.co.uk>...
>> Yes. But it depends on the client software you are using. We've done it
 in
>> both Pro*C and DAO in Visual Basic 5.
>>
>> Steve Phelan.
>>
>> SteverR wrote in message
>> <1998031903542601.WAA14929_at_ladder01.news.aol.com>...
>> >Is there a way to write a stored procedure that will send all the rows
 of a
>> >query to the client that executed the stored procedure so it can store
 all
 rows
>> >in memory and process row by row without having to use cursors and
 access
 row
>> >by row over the network?
>>
>>
>>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de